Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful.
This one’s for you, @SQLChicken! (Thanks to Adam Machanic for correction.) All: Feel free to print, link, or reuse…just don’t take my name off please. -Jen
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about a common theme I’ve been seeing lately: Proving facts to ignoramuses*. How to Prove Facts to the Unbeliever State the fact. Explain the fact. Restate the fact. [Realize here that they won’t listen […]