Create table #SampleData
(Returndate datetime,
Itemid nvarchar(35),
Qty int)

Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-06','HTC1201',100)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-06','LGE3539',200)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-13','HTC1201',150)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-13','LGE3539',100)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-20','HTC1201',400)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-20','LGE3539',400)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-27','HTC1201',100)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-07-27','LGE3539',100)
Insert into #SampleData (Returndate, Itemid, Qty) values ('2012-08-03','HTC1201',1000)

 
Result:
Itemid----6----13-------20-----27
---------------------------------
HTC1201--100---150-----400----100
LGE3539--200---100-----400----100


My Script:
SELECT *
FROM (SELECT Itemid, DAY(ReturnDate) AS trandate, Qty
      FROM #SampleData) AS D
  PIVOT(SUM(qty) FOR trandate IN([6],[13],[20],[27])) AS P
Order by Itemid  

exec dynamic_pivot 'SELECT Itemid, Qty from SampleData WHERE DAY(ReturnDate) <> 3' , 'DAY(ReturnDate)', 'SUM(qty)'

quote:

---

Originally posted by joe8079

Just had a quick comment about this post and a question. Wouldnt it be easier to use a matrix to do this dynamic pivot? I'm not sure if you have access to reporting services, but it seems like this could be done in a matrix by using column groups. If you dont have access to reporting services, then this code works fine, but your life would be much easier.

---