SELECT cast(recvdate as date) as recvdate,saveinit,count(*) AS numProcessed into #initials FROM PoReceiptsReport WHERE CAST(recvdate as date) > DATEADD(month,-4,getdate()) GROUP BY CAST(recvdate as Date),saveinit ORDER BY CAST(recvdate as Date),saveinit DECLARE @sql AS NVARCHAR(2000); DECLARE @saveinitvalues AS NVARCHAR(2000); SELECT @saveinitvalues = ISNULL(@saveinitvalues + ', ', '') + QUOTENAME(saveinit) FROM (SELECT DISTINCT saveinit FROM #initials) AS recvdate; SET @sql = N'SELECT recvdate, ' + @saveinitvalues + 'FROM #initials PIVOT(SUM(numprocessed) FOR saveinit IN (' + @saveinitvalues + ')) AS PivotSales'; EXEC sp_executesql @sql;My question for the moment...........