[SQL]How to dynamically number rows in a SELECT Statement

http://support.microsoft.com/default.aspx?scid=kb;en-us;186133