Do you know if there are any queries available for SQL 7 and SQL 2000?

Thanks for all your help. That query works great on SQL 2005. Do you happen to know what would be the fastest way to get the same results...

--===== Create the test table with

CREATE TABLE #mytable

(

...