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