Jeremy Stein - Brain

« »

SQL Server Recursive Join

I’ve read some annoying articles about recursive joins in SQL Server 2000. You know, where you have a table with id and parent_id and you want to get the whole hierarchy of elements. The short answer is: no. You can’t do that in SQL Server 2000.

You can in Oracle.

You can use a Common Table Expression in SQL Server 2005.

September 22, 2005 No Comments.

No Comments

Be the first to comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Why ask?

« »