Using CROSS APPLY instead of a calculated variable

(Kenneth Fisher) Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working on a series of audit queries for the last couple of weeks and got thrown a bit of a curve today. The original specs included several comparisons against a date. Basically the followin

Read More - Register for Free Membership