在sql service中，一个sql和存储过程，sql查询中需要这个存储过程中的数据，（存储过程需要参数），有什么办法能让sql和存储过程关联起来，在帆软设计器里面处理也行 WITH RootData AS ( EXEC Proc_STDF_HardBin_Rate_LotSummary @Customer='DSWA', @SDate='2024/7/15 0:00:00', @EDate='2024/7/21 0:00:00' ) SELECT td.Trackout_Date, td.Device, td.PoCustLot, td.LotID, rcs.CP_Step, tk.WaferID 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 RootData ON RootData.Device = td.Device AND RootData.WaferLot = td.PoCustLot -- 确保这里列名匹配返回的RootData中的列名 WHERE td.Trackout_Date >= DATEADD ( WEEK, DATEDIFF( WEEK, 0, GETDATE ( ) ) - 1, 0 )
AND td.Trackout_Date < DATEADD ( WEEK, DATEDIFF( WEEK, 0, GETDATE ( ) ), 0 )
AND td.Customer = 'DSWA' ORDER BY td.Trackout_Date; |
1min目标场景问卷
立即参与
