Skip to Content

Pivot Query for Day wise Production

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

SQL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers