bring back single line

Question

Post reply

bring back single line

Jeff Moden

SSC Guru

Points: 1004362
More actions
November 15, 2021 at 6:42 am
Answer
#3953031

I avoid the PIVOT operator and instead use the ancient "Black Art" of CROSSTABs because of more flexibility, functionality and performance.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-%e2%80%93-converting-rows-to-columns-1
If you want dynamic CROSSTABs, those are pretty easy, as well.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs
--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)

Viewing 4 posts - 16 through 18 (of 18 total)

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

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

Bruin wrote:

any examples of the dynamic pivot?

Sure, take a look here.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Bruin SSCrazy Points: 2058 More actions · Answer 2

Bruin

SSCrazy

Points: 2058

November 17, 2021 at 7:58 pm

#3954194

Thanks that helped me find a solution.

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 3

Bruin wrote:

Thanks that helped me find a solution.

Awesome. Thank you for the feedback!

--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)