You can’t use aggregate/windowing functions with CROSS APPLY

(Kenneth Fisher) One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well recently I was working on performance tuning a rather annoying query (which I will blog about in more detail later) and one of the steps I took was an attempt to combine CROSS

Read More - Register for Free Membership