How can I do the following in one nested query. I am using SQL Server 2005. Thanks
SELECT Program, PRC_PROGRAM_ID
INTO #TEMP
FROM tblPayment
GROUP BY PROGRAM, PRC_PROGRAM_ID
SELECT Program, COUNT(*) FROM #TEMP GROUP BY Program HAVING COUNT(*)>1
DROP TABLE #TEMP
