Loading

Dynamic Pivot Table

Manish Patat

5y954

I Have Row Output Dynamic generate Column through Pivot

My Table Output Look Like This

Query=Select HD.HEATNO,HD.METALCODE,MD.METALNAME from HeatDetail As HD Left Outer Join MetalDetails AS MD ON HD.METALCODE=MD.METALCODE Where HD.PHStr is Null

My Requir Output

Dynamic Generate for pivot

Thank in Advance ...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
1. WITH myQuery AS (
3. Select HD.HEATNO,HD.METALCODE,MD.METALNAME from HeatDetail As HD Left Outer Join MetalDetails AS MD ON HD.METALCODE=MD.METALCODE Where HD.PHStr is Null
5. )
6. select * from myQuery unpivot (value for Coll in ([HeatNo],[MetalCode],[MetalName])) up pivot (max(value) for Roww in ([6LXB-1],[6LXC-2],[6L2A],
7. [6L1B],[6LQF])) p

+1