Jeremy Stein - Brain
| « SQL Server View Ignores Order By | Firefox update hangs » |
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 use a Common Table Expression in SQL Server 2005.
No Comments
Be the first to comment!
| « SQL Server View Ignores Order By | Firefox update hangs » |
Leave a Reply