Posted by Nick Chan on 09/28/07 10:12

hello, what are the strategies when designing tables that needs
paging?
in the past i used to use

select top 200 * from table
where id not in (select top 100 id from table)


with SQL 2005, would u guys recommend using CTE and/or ROW_NUMBER?

or any other advice?

thanks

• Next in forum: Re: TDS and character encoding
• Prev in forum: Re: TDS and character encoding
• Thread view: strategies for paging

[Reply to this message]