Posted by jim_geissman on 10/11/06 15:04

Thank you very much, Alex. That's tremendous.
I learned three new things -- row_number, over and partition.
No wonder I was having trouble.

Thanks again,
Jim
> -----------------------
> Alex Kuznetsov
> http://sqlserver-tips.blogspot.com/
> http://sqlserver-puzzles.blogspot.com/

• Next in forum: SQL 2005 Processor VS Cal
• Prev in forum: Re: clever date to find most recent .bak file
• Thread view: Re: Double summation

[Reply to this message]