GROUP BY

Question

Post reply

GROUP BY

santoshghogare2008

SSC Veteran

Points: 219
More actions
June 12, 2018 at 3:26 am

#369760

Hi All,
i won't following output.find attachment for same.
multiple row of columns.
please suggest.
regards
santosh
Best Regards
Santosh Ghogare

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Phil Parkin

SSC Guru

Points: 247180

June 12, 2018 at 4:28 am

#1993655

Use SSRS, or some other data presentation tool.

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 2

santoshghogare2008 - Tuesday, June 12, 2018 3:26 AM
Hi All,
i won't following output.find attachment for same.
multiple row of columns.
please suggest.
regards
santosh

This is known as a "CROSSTAB" or "PIVOT" and I recommend the use of the former...

See the following articles for how they work...
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)