How to write the Pivot Query For This Sql Server

Question

hi

I need How to Join Multiple Tables but sum function populate no question show like this n/a
see below text File.(Details)

Execute the sql Query in Text File

SqlQuery1.txt -> File.

see my Attachement i need output like this image

Ineedthis.JPG

Chetan Kumar · Answer

Hi Please find the syntax for Pivot with result set SELECT HeatNo[cr][ni][si][mn] --qty FROM (SELECT HeatNochempty qty FROM #tbl1)m PIVOT ( MAX(Qty) FOR chempty IN([cr][ni][si][mn]))as pvt HeatNo cr ni si mn 1024 1.25 0.50 NULL NULL 1025 2.00 NULL 1.50 NULL 1030 NULL NULL NULL 1.00