Thanks for the great question.

Window functions are really useful, and can make some complicated queries much simpler.

However, its one area that I really wish SQL Server would catch up to...

Nice article, thanks for sharing.

The same thing can be achieved with just the row_number function as well.

select AlphaKey

from (

select row_number() over(partition by AlphaKey order by AlphaKey) rownum,

AlphaKey...

Hi Zach, I think thats a pretty neat approach.

With large tables I prefer to use table partitioning, which gets around the issue of locking a live table for an extended...

Great article. Thank you for providing this information David.

Your article saved me a great deal of work this morning thanks to the SQLCMD information you provided.

Regards

Scott

Howdy, thanks for the interesting question.

The 3rd answer was wrong for my DOB. It showed a younger value though, which is appreciated.