What is the purpose of using the Rows Unbounded Preceeding clause in a window function?
I think I understand that it's basically saying not to limit how far back to look when rolling up for the aggregate function, but how is that different than not using the clause at all?
Could you please provi...
You should totally post this as an answer so I can accept it, because that literally explained everything I needed to know in 60 seconds. :) Also, thanks for the info on the window spool operator! — J.D.3 hours ago
New user confuses comment box with answer box
Somewhat ironically, Josh is the best and most helpful main-site user.
What is the purpose of using the Rows Unbounded Preceeding clause in a window function?
I think I understand that it's basically saying not to limit how far back to look when rolling up for the aggregate function, but how is that different than not using the clause at all?
Could you please provi...
@JoshDarnell That's part of it for sure, but writing about something is good to (a) make sure you understand it yourself; and (b) don't have to work it all out from scratch next time you need the info yourself
@Lamak Yes: stealing whole posts is naughty "not really on"
My gripe about my coworkers not reading was not about views, by the way. We just have worked together for 5 years, and are all somewhat close. And I know they follow several blogs.
Because they don't know what they are doing and have not for a single moment understood what makes X-Men special. It's also been a production dumpster fire and Dark Phoenix requires avengers level set up.
It is. If I query the data with XQuery, it shows up as resolved. For some reason, viewing the exact same thing in the SSMS file target UI shows addresses only.