>
I hope this could help to John, but this really helps to me.
>Thank you. >
>No problem, glad it helped.
>
>CTEs and recursive queries are great, and can be used to address many situations. They're my favorite language enhancement in SQL '05.
No doubt about it.
I very unhappy I can't use them. the standard here is SQL Server 2000 and NOBODY could force the users to buy licenses for SQL 2005.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.