Oh, believe me, I have tons of my own WTFs. You have none?
Once you guys put me on to the fact that this is doing something I would have done with NOT EXISTS or NOT IN, I started looking at it more closely and found that, at least in this enviornment, this approach runs significantly faster. Huh. It doesn't just work, it works really well.
If you think being in a business for eight years means you ought to have nothing left to learn, and never make another mistake, let us know how that attitude is working for you in, say, another eight years.@beginner_ said:
@darkmattar said:
Considering that this looks like perfectly valid SQL to find orphans to clean up, I hope you will post some of your own SQL because I think it will be more entertaining for us!And since he joined here in 2005, I guess I has had at least 8 years to create a ton of WTFs!