GrassHopper (3/1/2015)
I tried this but it only gives me the first column.... what am I doing wrong?
Since your code has no formatting it is hard to tell for sure. The biggest thing you are doing wrong however is you didn't read the article Jeff recommended about how to post. We can't see your screen. The only information we have is what you posted, which isn't much at this point. Help us help you by giving us some details.
The logistics of what you are doing isn't that bad. I have to agree with Jeff though that the datatypes and names are pretty horrific.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/