I continue a series on window functions in SQL Server:
To this point, we’ve looked at five classes of window function in SQL Server. I’ve given you a couple of solid use cases, but for the most part, we’ve focused on what the classes of window functions are. Now we’re going to talk about why you want to use them.
As is the norm for me, it takes about seven posts before I explain why you might want to do something.