Luis Cazares (1/16/2014)
Sean Lange (1/16/2014)
What is the expected output based on the sample data?
Hey Sean,
It seems that the OP wrote the expected results and attached the sample data. So adding message column to the group by seems to work fine.
Ahh yes. I didn't look at the picture because...well...because so often the attached pictures provide little to the discussion. In this case apparently it did. 😀
_______________________________________________________________
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/