在数据库中可以直接将存储过程返回的结果写入一个临时表里,但是帆软里好像用不了,现在有两个数据集,一个存储过程,怎么将数据集a像sql一样左关联存储过程返回的结果,然后再左关联数据集b,下面是sqlIF OBJECT_ID( 'tempdb..#TempResults' ) IS NOT NULL BEGINDROP TABLE # TempResults;END;CREATE TABLE # TempResults ( Device VARCHAR ( 160 ), ASSYLOT VARCHAR ( 160 ), WaferLot VARCHAR ( 160 ), WaferID VARCHAR ( 160 ), TesterNo VARCHAR ( 160 ), ProberNo VARCHAR ( 160 ) );INSERT INTO # TempResults ( Device, ASSYLOT, WaferLot, WaferID, TesterNo, ProberNo, ) EXEC Proc_STDF_HardBin_Rate_LotSummary @Customer = 'DSWA' SELECT DISTINCTtd.Trackout_Date,td.Device,td.PoCustLot,td.LotID,rcs.CP_Step,tk.WaferID,tr.TestProgram,tr.TesterNo FROM tD_LotTrackData td LEFT JOIN RPT_CFG_Step rcs ON td.Step_Code = rcs.MES_Step LEFT JOIN tD_LotWaferTrack tk ON td.LotID = tk.LotID LEFT JOIN # TempResults tr ON td.Device = tr.Device AND td.PoCustLot = tr.WaferLot AND tr.WaferID = tk.WaferID WHERE td.Customer = 'DSWA' AND td.Trackout_Date >= DATEADD( WEEK, DATEDIFF( WEEK, 0, GETDATE( ) ) - 1, 0 ) -- 上周的周一 AND td.Trackout_Date < DATEADD( WEEK, DATEDIFF( WEEK, 0, GETDATE( ) ), 0 ) -- 本周的周一