在存储过程中调用别的存储过程，把结果保存到临时表中

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