Loading

How to write the Pivot Query For This Sql Server

Josephs

14y1.6k

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

1 Reply

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

Chetan Kumar14y ago
Hi,

Please find the syntax for Pivot with result set SELECT HeatNo,[cr],[ni],[si],[mn] --,qty
FROM
(SELECT
HeatNo,chempty ,qty
FROM #tbl1)m
PIVOT
( MAX(Qty) FOR chempty IN([cr],[ni],[si],[mn]))as pvt

HeatNocrnisimn
10241.250.50NULLNULL
10252.00NULL1.50NULL
1030NULLNULLNULL1.00