Thank you so much!! This is awesome and works great! After running it through all of the real data I found a few more problems however I was able to...

Thank you very much for the help.

I couldn't change the database compatibility level due to a lot of old stuff so I created the view in a new database and...

Thanks heaps guys. I'm nearly there now but just getting an error with the CROSS APPLY:

"Msg 321, Level 15, State 1, Line 3

"attributevalue" is not a recognized table hints option....

Ok so I can get the 'CSV Splitter' working but that only does a string. I need to read the data in from a table which could have any number...

Thanks for the reply. I had a look at that page and it's going to take me some time to understand that so I'll see how I go.

Oops sorry. I just noticed I put this into SQL Server 2008 instead of 2005. Can someone move it please?