I'm not sure exactly what the result would look like because they're just asking it from me. However, I'd like to see what the guru's would write based on the information. Please if possible.
So I am guessing now that since you removed the contents of your post you don't want any help?
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 Moden's splitter
.Cross Tabs and Pivots, Part 1 – Converting Rows to Columns Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs Understanding and Using APPLY (Part 1)Understanding and Using APPLY (Part 2)