WHERE CASE WHEN @miDATE IS NULL THEN 1
ELSE case when OUT.LLDATE Between @miDATE And @maDATE then 1 else 0 end END=1
AND OUT.OUTDATE IS NOT NULL
ELSE case when OUT.LLDATE Between @miDATE And @maDATE then 1 else 0 end END=1
AND OUT.OUTDATE IS NOT NULL
当 miDATE为空时 为 全部记录
当 miDATE 不为空时,取出 OUT.LLDATE 介于 @miDATE 和 @maDATE 之间的记录吗?