In Oracle, you have LAG and LEAD analytic functions which allow access of rows around the current row. If SQLServer has this, it could also have been used rather than joining to rownum=rownum-1

__________________
DW1 DW2 DW3 DW4 DNU PQ