Cannot index the view '. It contains one or more d
SELECT dbo.WEA_WeavingDetail.sysWeavingDetailNo, dbo.WEA_WeavingDetail.DyeSet_Code, dbo.WEA_OrderIntimationDetail.Dyeing_Code,
dbo.WEA_WeavingDetail.Fabric_Code, dbo.WEA_OrderIntimationDetail.Weaving_Code, dbo.WEA_WeavingDetail.Lot_No,
dbo.WEA_WeavingDetail.Beam_No, dbo.WEA_WeavingDetail.Loom_No, dbo.WEA_WeavingDetail.Warp_Length,
SUM(dbo.WEA_DoffDetail.Fabric_Length) AS Fabric_Length, COUNT_BIG (*) AS CNT
FROM dbo.WEA_WeavingMaster INNER JOIN
dbo.WEA_WeavingDetail ON dbo.WEA_WeavingMaster.sysWeavingMasterNo = dbo.WEA_WeavingDetail.sysWeavingMasterNo INNER JOIN
dbo.WEA_OrderIntimationDetail ON
dbo.WEA_WeavingDetail.sysOrderIntimationNo = dbo.WEA_OrderIntimationDetail.sysOrderIntimationNo INNER JOIN
dbo.WEA_DoffDetail ON dbo.WEA_WeavingDetail.sysWeavingDetailNo = dbo.WEA_DoffDetail.sysWeavingDetailNo
GROUP BY dbo.WEA_WeavingDetail.sysWeavingDetailNo, dbo.WEA_WeavingDetail.sysOrderIntimationNo, dbo.WEA_WeavingDetail.DyeSet_Code,
dbo.WEA_WeavingDetail.Fabric_Code, dbo.WEA_WeavingDetail.Lot_No, dbo.WEA_WeavingDetail.Beam_No, dbo.WEA_WeavingDetail.Loom_No,
dbo.WEA_WeavingDetail.Warp_Length, dbo.WEA_OrderIntimationDetail.Weaving_Code, dbo.WEA_OrderIntimationDetail.Dyeing_Code
|
