June 12, 2012 at 12:18 pm
Post removed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2012 at 12:28 pm
Could be a candidate for a PIVOT, but hard to tell without table definitions, sample data, and all the stuff the first link on your signature line asks for 😀
June 12, 2012 at 12:58 pm
I hope this is clear
Yeap clear as mud. Just once it would be nice if you actually followed the advice you offer to others by actually reading the article you reference in your signature.
This could be a cross join, pivot, tally table, or a host of other possibilities. Ask yourself if you think you could answer your questions based on what you posted. I would guess the solution will take barely a few minutes once you post details.
_______________________________________________________________
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/
June 12, 2012 at 1:13 pm
Have to agree, clear as the Hudson River.
What the heck are all the X's? There is nothing to say what they mean.
Please, following the instructions in the article in your signature block and post DDL, sample data, expected results, and the code you have written so far in an attempt to solver your problem.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply