Skip to Content
0

Pivot Query for Day wise Production

Oct 27, 2017 at 11:17 AM

8

avatar image

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers