April 17, 2014 at 2:42 am
Hi all,
I need to display the output of a table in a specific format, I have attached the sample screenshot and code for reference.
I tried with pivot but does not seems to be working.
Can any body please look into it and give some suggestions.
Any help will be highly appreciated.
Regards.
April 17, 2014 at 3:01 am
Is it an option to create a report? (it will be much easier)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 20, 2014 at 2:51 am
the following excellent articles by Jeff Moden may help you on your way
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
as a sidebar...I would start using datetime for your month names....you are likely to get into all sorts of problems on sorting them correctly if you don't.
http://www.sqlservercentral.com/articles/T-SQL/71511/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply