[易飞]三、邮件预警-厂内超期（14天）未完工工单

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'