Bob Hovious (3/14/2009)
my requirement is that i have get the details about the parentid's along with the recursive data' in a single join
Test question?
I've been taking buisness requirements for years, and never once has "in a single join" been specified as a requirement. So who made it mandatory for you?
Heh... I've found that most folks that want it in a "single join" or "single query" are doing it because they intend to embed the code in a GUI rather than writing it in a stored proc. That certainly doesn't make it right, though.
--Jeff Moden
Change is inevitable... Change for the better is not.