本文提供了一段SQL查询代码，用于从数据库中选取在指定日期前输入且未被处理的有效卡片记录。通过分组和子查询的方式确保所选卡片为最新且有效的。
--得到有效卡片
SELECT sCardID FROM fa_Cards
WHERE fa_Cards.sCardID IN(SELECT Max(sCardID) FROM fa_Cards
WHERE (((fa_Cards.dInputDate)<=@LoginDate) AND ((fa_Cards.dTransDate)<=@LoginDate Or (fa_Cards.dTransDate) Is Null) AND ((fa_Cards.dDisposeDate)<=@LoginDate Or (fa_Cards.dDisposeDate) Is Null))
GROUP BY fa_Cards.sCardNum)
SELECT sCardID FROM fa_Cards
WHERE fa_Cards.sCardID IN(SELECT Max(sCardID) FROM fa_Cards
WHERE (((fa_Cards.dInputDate)<=@LoginDate) AND ((fa_Cards.dTransDate)<=@LoginDate Or (fa_Cards.dTransDate) Is Null) AND ((fa_Cards.dDisposeDate)<=@LoginDate Or (fa_Cards.dDisposeDate) Is Null))
GROUP BY fa_Cards.sCardNum)
扫一扫
1839
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
