Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 11
Newest
 Teacher
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
May
15
awarded  Teacher
May
15
answered List the underlying objects used in a SQL Server Function
May
15
accepted List the underlying objects used in a SQL Server Function
May
15
comment List the underlying objects used in a SQL Server Function
Hi. This is awesome! it worked for 2 functions, but strangely the 3rd functions object id wasn't even in the table. So I did a bit of googling and came across sys.sql_expression_dependencies which had all the objects. Details in my answer below. Also thank you, I am marking this as answered.
May
15
asked List the underlying objects used in a SQL Server Function
May
10
awarded  Curious
Dec
15
awarded  Popular Question
Sep
25
awarded  Notable Question
May
28
revised Converting multiple SQL implicit joins into explicit joins
added 2 characters in body
May
28
comment Converting multiple SQL implicit joins into explicit joins
Hi Ted, could you kindly help me understand your steps 9,10 that I have updated in my question..? Thanks
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 14 characters in body
May
13
comment Converting multiple SQL implicit joins into explicit joins
I have updated by question with my understanding of your algorithm.. It's too long to read :). Here is where I am stuck - for "c.c_id = h.c_id(+)" => c LEFT JOIN h. But above we are not getting all the records of c to participate in the join with h, ..correct?
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 2497 characters in body
May
13
revised Converting multiple SQL implicit joins into explicit joins
added 66 characters in body
May
13
comment Converting multiple SQL implicit joins into explicit joins
Hi @Ted, really appreciate your explanation! Need a few mins to understand how the intermediate joins work..
May
13
comment Converting multiple SQL implicit joins into explicit joins
Hi @siride, as mentioned I am looking for example/guides/formal specs on how to resolve this. Consider: Line 3,4: c LJ h; Line 5,6: h LJ g - now how do I combine these two..? c LJ h <LJ/RJ/IJ> h LJ g - doesn't seem right..
May
13
revised Converting multiple SQL implicit joins into explicit joins
edited title
May
12
revised Converting multiple SQL implicit joins into explicit joins
added 65 characters in body
May
12
revised Converting multiple SQL implicit joins into explicit joins
deleted 120 characters in body
May
10
revised Converting multiple SQL implicit joins into explicit joins
added 104 characters in body