Define 'previous' and 'next'? Tables have no order, so what column is the one that defines which row is the next row?
And why the restriction against the row number function?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability