sunitkrishna (4/13/2015)
Sean,Thanks for the answer.
This will work only when the designations are known beforehand,right?
In my case the designations are not fixed and we take the values from the designation table.
Any solution for this issue?
regards,
Sunitha
That is correct. You will have to add another level of dynamic sql here to build the columns dynamically. I showed you how to do the hard part. I will leave the dynamic columns up to you. What have you tried there?
_______________________________________________________________
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/