摘要:
SELECT DISTINCT SUBSTRING(CuttingPR.CuttingColorNO, 0, CHARINDEX('#', CuttingPR.CuttingColorNO)) AS 订单号 ,CuttingPR.CuttingBatchNO as 裁剪批号 ,SUBSTRING(CuttingPR.CuttingColorNO,11,6) AS 花色号 , MaterialC.A... 阅读全文
摘要:
SELECT DISTINCT SUBSTRING(CuttingPR.CuttingColorNO, 0, CHARINDEX('#', CuttingPR.CuttingColorNO)) AS 订单号 ,CuttingPR.CuttingBatchNO as 裁剪批号 ,SUBSTRING(CuttingPR.CuttingColorNO,11,6) AS 花色号 , MaterialC.A... 阅读全文
|