thanks very much; Im sure there will be something 🙂

I see what your saying and it makes sense.... I will proceed with the reading!! thanks

Thanks for that; as you can tell Im a developer not a DBA! trying to get more familiar with the aspects of querying SQL databases. at the moment reading T-SQL...

with (nolock) just stocks the query locking the table. this is essential if you are querying a live database!! 🙂

If you want to get the rowid for the use in a paging query then use row_count()

declare @FromRow int

declare @ToRow int

set @FromRow = (@PageNo-1) * @pageSize

set @ToRow = @FromRow +...