Even with a category your next problem is row order. You mention a requirement to identify subsequent rows but there is no column that will allow you to identify subsequent or preceding rows.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]