Convert the Column value to Row in SQL Query using SP

[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…