Hi @Ronen, 
Thanks for your information. 
I already went through the link you shared and some others such as
https://blogs.msdn.microsoft.com/craigfr/2008/10/07/random-prefetching/
and
https://sqlserverfast.com/epr/nested-loops/
and i agree with...

Yes, left join is fixed better than inner join in this case 🙂

In my case, i don't need to calc to root node so inner join is find for me

Regards,...

Jason-299789 (9/12/2012)

---

This seems like a piece of course work or a test thats been set internally by a senior.

However this code will work for any number of levels required though...

First of all,

Sorry that i don't follow the rule of forum, i will do that when create next threads 🙂

@dwain.c: thanks for your data and solution. I will edit...

hi ,

Because i'm still thinking about this problem and don't come up with...

shairal_t (6/2/2010)

---

I have lots of databases that were created by several people - so they ended up being 'owned' by each of the creators. I would like (if possible)...

Paul White (1/28/2010)

---

From Books Online:

So, I would suggest...

I get from some sps...

Dave Ballantyne (1/20/2010)

---

Why would you want such a thing ?

Imagine if it 'auto-generated' a name such...

Use dynamic sql is not what i mean in the first post.

If you don't know how much column which the result set will return and which column have a name...

Thanks very much 😀

It took me one day to search and I finally found the way out in here.

Sol

Lamprey13 (10/14/2009)

---

sol-356065 (10/12/2009)

---

SQL does not have a "first" row. Sets do not have any order.

You need to apply an order to the data in order to determine what "first"...

@arun.sas:

thanks for your solution :), i checked performance of this method and my method, it is nearly the same(around 2mil records)

i just checked the time which the...

To ARUN SAS,

Although the sp_helptext return full length of sp, but it's just for one sp 🙂

To John Marsh,

Yeah, the sys.sql_modules help me very much,

thanks all of you

While i...

Thanks very much,

And i hope you don't take so serious about what i said :).

The result i expect is only for me to see, and it has nothing to do...