jts_2003 (7/2/2010)
I think this is an example of why people don't like to use OVER, since it's so hard to work out what might/will be returned!I'd like to see a simpler question or articles on how OVER works - any takers?
It's not that hard at all, once you understand it. Did you see this article[/url] that was just recently published in April?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes