在数据库中可以直接将存储过程返回的结果写入一个临时表里,但是帆软里好像用不了,现在有两个数据集,一个存储过程,怎么将数据集a像sql一样左关联存储过程返回的结果,然后再左关联数据集b,下面是sql IF OBJECT_ID( 'tempdb..#TempResults' ) IS NOT NULL BEGIN DROP 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 DISTINCT td.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 ) -- 本周的周一 |