Skip to Content
0
Oct 27, 2017 at 11:17 AM

Pivot Query for Day wise Production

30 Views

Sir,

Kindly help me to Pivot This Query

SELECT datepart(dd, T0.[PostDate]) as Day,T0.[ItemCode], T1.[ItemName],T0.[CmpltQty] FROM OWOR T0 , OITM T1 WHERE T0.[ItemCode] = T1.[ItemCode] AND T0.[PostDate] >=[%0] AND T0.[DueDate] <=[%1]

Regards,

Krishna Kumar