解决方案１：
CREATE TABLE #tmpBus
(
COL1 INT,
COL2 INT
)
INSERT INTO #tmpBus
Exec SpGetRecords ‘Params‘
解决方案２：
SELECT * INTO #MyTempTable FROM OPENROWSET(‘SQLNCLI‘, ‘Server=(local)\SQL2008;Trusted_Connection=yes;‘,
‘EXEC getBusinessLineHistory‘)
原文：http://www.cnblogs.com/bi-info/p/6215343.html