SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2 | Journ

As other people have already pointed out, this definitely doesn’t work on SQL Server 2000. SQL server 2000 users have no access to CTEs and ROW_NUMBER, since both were ...

blog.sqlauthority.com