Daily sales report with last selling price

Hi,

Try this........

SELECT P.CardCode,P.CardName,P.ItemCode,
[1] as [Jan],
 [2] as [Feb],
 [3] as [Mar],
  [4] as [Apr],
 [5] as [May],
 [6] as [Jun],
 [7] as [Jul],
 [8] as [Aug],
 [9] as [Sep],
 [10] as [Oct],
 [11] as [Nov],
 [12] as [Dec]
 
FROM (SELECT (T0.CardCode),T0.CardName,t1.ItemCode,T1.price,MONTH(T1.Docdate)as month
FROM dbo.OINV  T0
inner join INV1 T1 ON T0.DocEntry=T1.DocEntry
inner join OITM t2 on T1.ItemCode=t2.ItemCode  
WHERE T1.DocDate>='[%0]' and T1.DocDate<='[%1]' and T1.ITEMCODE='[%2]' 
and T0.CardCode='[%3]'
) S
  PIVOT  (max(price) FOR [month] IN 
([4],[5],[6],[7],[8],[9],[10],[11],[12],[1],[2],[3])) P
ORDER BY P.[CardCode] 

Check this link for SQL tutorials.........

http://beginner-sql-tutorial.com/sql-subquery.htm

http://w3schools.com/sql/default.asp