Converting multiple Columns of a table into multiple Rows with all other rows repeating

Question

I have something like this

Id	ddf1	ddf2	ddf3	ddf4
1	223	112	221	500

I want something like this

I've other columns too in my query. So i want a solution which doesn't effect my other columns.

37 thousand rows of code, to unpivot 4 columns? That sounds highly inefficient. — Thom A, Apr 20 '22 at 10:50
@Larnu im doing data migration which involves many tables through join, it's partitioned. For one partition i need unpivot. Btw issue is now solved — Harsha Deep, Apr 26 '22 at 15:18

score 0 · Accepted Answer · answered Apr 20 '22 at 10:46

0

you can do something like this. See working fiddle here

select id,ddfs
from yourtable t cross apply
(values ('ddf1',t.ddf1),('ddf2',t.ddf2), ('ddf3',t.ddf3) ,('ddf4',t.ddf4)) v(k,ddfs)

answered Apr 20 '22 at 10:46

DhruvJoshi

1 Answers1