1.创建一个本地临时表
2.将动态执行的结果集插入到临时表,
3.对临时表进行操作
CREATE TABLE #TEMP (
SupportID INT,Keywords INT,
CityId INT,
RegisterNum INT
)
INSERT INTO #TEMP
exec [dbo].[sp_Regisger2015] 0,0,'2015-05-10 00:00:00','2015-05-27 23:59:00'
SELECT SUM(RegisterNum) FROM #TEMP GROUP BY SupportID