October 4, 2011 at 10:10 am
Hi. It seems you are somewhat new around here. Welcome. Before we have a chance at helping you with your issue you need to provide some details. If you want tested and accurate code you need to post ddl, sample data (insert statements), desired output based on your sample data. Without that the best we can do is take a stab in the dark. Take a look at the link in my signature for best practices on how to collect this information and post it in a consumable format.
_______________________________________________________________
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/
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply