July 28, 2013 at 5:39 pm
I need to write a query without using pivot. Here is the scenario
need to display summition of data yearly and year should be display on columns.
example- Input
IDAmountYear
1501981
12001981
23001982
3701985
25001981
output
ID1981198219831985
1250
2500300
370
Please help..
July 28, 2013 at 6:53 pm
I suggest you look at the following 2 articles and they'll give you the answer you seek:
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply