22,206
社区成员
发帖
与我相关
我的任务
分享
COUNT( CASE
WHEN ((ISNULL(B.LeijiShuLian, 0) >= ISNULL(a.ShuLian, 0)) OR (ISNULL(B.LeijiShuLian, 0)*0.95 >= ISNULL(a.ShuLian, 0)))
AND c.MAXKdReQi <= COALESCE(DATEADD(DAY, 2, a.DHReQi), CONVERT(CHAR(10), GETDATE(), 20))
THEN 1
END
);