As new records are added to a table, I need to mark the old records for that 'level' as old. I can do this with a NOT IN, but NOT EXISTS does not work. I suspect it has to do with subquery correlation as explained here: As new records are added to a table, I need to
阅读背景：
T-SQL不在工作中，但不存在。
来源：互联网
分享到：
