SQL:
SELECT MOCTA.TA001+'-'+MOCTA.TA002 单据号, ZE.dbo.Date10(MOCTA.TA040) 单据日期, MOCTA.TA006 品号, MOCTA.TA034 品名, MOCTA.TA035 规格, ZE.dbo.Date10(MOCTA.TA010) 预计完工日, convert(decimal(15,2),MOCTA.TA015) 预计产量,convert(decimal(15,2),MOCTA.TA017 ) 已生产量, convert(decimal(15,2),TA015-TA017) 未生产量, CAST(Convert(decimal(18,2),(TA015-TA017)*100/TA015) AS NVARCHAR)+'%' 未生产量百分比,DATEDIFF(DAY,TA010,GETDATE()) 超期天数, MOCTA.TA033 计划批号
FROM ZE.dbo.MOCTA MOCTA
WHERE (MOCTA.TA030 = '1')
AND (MOCTA.TA011 <> 'Y')
AND (MOCTA.TA011 <> 'y'
AND MOCTA.TA011 <> '1')
AND (MOCTA.TA013 = 'Y')
AND datediff(d,MOCTA.TA010,CONVERT(CHAR(8),GETDATE(),112))>14 AND MOCTA.TA001<>'5109'