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 ...