Convert the Column value to Row in SQL Query using SP

[vipin_jha123]

Hi All,

I am working on one requirement where I need to convert the Column value in to Row for one set of record.
My source table is getting populated from json file.

Please help me to achieve this .

Thanks in advance.
Regards,
Vipin Jha

[yosiasz]

This should help you

Need to get he output in below format uisng Pivot or Unpivot

Hi All, I have an requirment where I want to convert column in to below 2 format . Query to populate the table with data CREATE TABLE bil ( Due_Date date, ID BIGINT, Payment int, CODE NVARCHAR(10) ) INSERT INTO bil SELECT '01-10-2021', '56536' , 63 ,'CIS' UNION ALL SELECT '01-10-2021', '56536' , 6 ,'PTD' UNION ALL SELECT '01-10-2021', '56536' , 87 ,'ELM' UNION ALL SELECT '01-11-2021', '56536' , 63 ,'CIS' UNION ALL SELECT '01-11-2021', '56536' , 6 ,'PTD' UNION ALL SELECT '01-11-20…

[vipin_jha123]

I do not have to perform any aggregation on my data. I given example aggregation has been use

[robert_volk]

PIVOT requires an aggregate function. Your example would use MAX() or MIN(); they work for any data type, and if you only have one value then they'd both return the same thing.

[JeffModen]

@vipin_jha123

I do not have to perform any aggregation on my data. I given example aggregation has been use

@vipin_jha123
Hi, Vipin,

If you'll take the time to provide the source data in a readily consumable format (use a CREATE TABLE and provide the data in the form o INSERT/VALUES), I'll show you how with code.

Also, PIVOT kinda sucks for performance and flexibility. What you really want is a CROSSTAB and, again, if you provide the original data in the readily consumable format I just described, I'll show you how.