SELECT     CASE WHEN RefreshStatus = 'Delivered' THEN 'Delivered to date' ELSE refreshstatus END AS [Refresh Status], COUNT(refreshstatus) AS Count
FROM         refresh_report_status_tracker
GROUP BY refreshstatus

SELECT *
FROM (SELECT CASE WHEN RefreshStatus = 'Delivered' THEN 'Delivered to date' ELSE refreshstatus END AS [Refresh Status], 
COUNT(*) AS [Count]
FROM table
GROUP BY CASE WHEN RefreshStatus = 'Delivered' THEN 'Delivered to date' ELSE refreshstatus END )t
PIVOT (SUM([Count]) FOR RefreshStatus IN ([Contacted], [Build] ,[ReadyToBuild]))p

quote:

---

Originally posted by darms21

Msg 207, Level 16, State 1, Line 6
Invalid column name 'RefreshStatus'.

I don't know the PIVOT function well, any idea why that error is?

---

SELECT *
FROM (SELECT CASE WHEN RefreshStatus = 'Delivered' THEN 'Delivered to date' ELSE refreshstatus END AS [Refresh Status], 
COUNT(*) AS [Count]
FROM table
GROUP BY CASE WHEN RefreshStatus = 'Delivered' THEN 'Delivered to date' ELSE refreshstatus END )t
PIVOT (SUM([Count]) FOR [Refresh Status] IN ([Contacted], [Build] ,[ReadyToBuild]))p