Sean good question. The multiple rows are NOT versions. There are actually more columns in the db than I posted and one of them is [version]. Not...

All of your assumptions are correct. If we can get away with doing this all in SQL Server, that would be great. While I can easily write something...

Hi All! It is SQL 2005. I thought I had posted this there. Sorry about that.

You're right he's not a dba and wouldn't I love to show him your comments!! hehehehe!

Glad I was able to share a good laugh.  I'm constantly laughing over here!...

Thanks for your help.