using Sql without using Pivot .

Question

Post reply

using Sql without using Pivot .

jagjitsingh

Ten Centuries

Points: 1063

March 10, 2025 at 1:09 pm

#4555829

Hi

How to get the below data we can create dynamically using Sql in a Table and then display using query. I will not be using Pivot .


  I want to display data like below without Pivot. Locations can be more. How it can be done without using Pivot

  Location 1Location 2Location 3Location 4
      
Item1Event110   20 
Item2Event2           30   10                  5

Thanks

March 10, 2025 at 6:52 pm

This was removed by the editor as SPAM
March 10, 2025 at 6:54 pm

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

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

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

You have >1,000 points, so you must know by now how to provide sample data (in the form of CREATE TABLE and INSERT statements) and desired results based on that sample data.

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

jagjitsingh wrote:

Hi
How to get the below data we can create dynamically using Sql in a Table and then display using query. I will not be using Pivot .
  I want to display data like below without Pivot. Locations can be more. How it can be done without using Pivot

  Location 1Location 2Location 3Location 4
      
Item1Event110   20 
Item2Event2           30   10                  5

Thanks

Like this if you have a fixed number of Locations...

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

... and like this if they're not...

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)