| IF OBJECT_ID('tempdb..#Encap_Code_List') IS NOT NULL DROP TABLE #Encap_Code_List; CREATE TABLE #Encap_Code_List (Encapsulation VARCHAR(50),DEVICE_NO VARCHAR(50)); INSERT INTO #Encap_Code_List (Encapsulation,DEVICE_NO) SELECT DISTINCT Encapsulation,DEVICE_NO FROM Equ_Device_List WHERE Install_Address = '东莞2D1F分粒' AND Encapsulation IS NOT NULL; select d.XUDF005,b.Item_Name,c.Encap_Name,e.Sequence_Desc,d.DOC_Name,d.DUDF023 ,a.Plan_Qty,Field_Days,a.Task_No,GJ_Wait_Days,e.RtionTime,Field_Days,g1.Item_Name ,d.DUDF024 from dbo.Sfc_Task_List a with(noLock) left join Epd_Item_Detail b on a.Item_Code = b.Item_Code left join Sjd_Encap_List c with(noLock) on c.Encap_Code = b.Encapsulation left join Mps_Plan_Bill d with(noLock) on d.Task_No = a.Product_Task left join Sjd_Procedure_List e with(noLock) on e.Sequence_No = a.Cur_Seq left join Sfc_Outsourcing_List_D f with(noLock) on f.Task_No = a.Task_No and f.Sequence_No = a.Cur_Seq left join Sfc_Outsourcing_List g with(noLock) on g.OutCode = f.OutCode left join Epd_ItemName_sf_V g1 on g1.Task_No = a.Product_Task left join #Encap_Code_List ENCP ON ENCP.Encapsulation = a.Encap_Code where a.Cur_Seq in ('1270','1280') and a.Task_No <> a.Product_Task and isnull(a.del_flag,'')<>'Y' AND Task_Status<>'F' and a.Cur_Seq<=3000 and isNull(a.Merge_Flag,'N') <> 'Y'
代码如下 有时候可以执行,有时候又提示上面的错误 |
1min目标场景问卷
立即参与
