sqlserver rownum equivalent

There's apparently no equivalent for Oracle's rownum in SqlServer, so this page came in handy for doing the equivalent.