select * into #tmp from
OPENROWSET(‘SQLOLEDB‘,‘SERVER=192.168.8.17;uid=fly;pwd=cim@2009;Database=scanpack‘,
‘SET FMTONLY OFF;exec sp_Proportion_Report‘) as a
在存储过程中调用别的存储过程,把结果保存到临时表中
原文:http://www.cnblogs.com/qshhq/p/6783589.html