The script for SQL 2000 still needs some adjusting. It's using a CROSS APPLY and a FOR XML that the query analyzer is complaining to me about. I got side-tracked...

Thanks Lowell!

Your code is for SQL 2005. I'll try and retool it for SQL 2000 and send it back to you.

Matthew

Great! I didn't mention earlier, but we are using a dev to staging to production to post production work flow. All is wonderful until the client of an active project...

Frickin awesome Lowell. This looks like what I'm trying to do. You are hurting me with the Cursor though. I read your use clause and will send you back the...