Right Question?

Hi Group,
I have a question in SQL Server 2000.
The question is, I have a table with 2 millions of records and I want
to fetch the record from 200 to 400 rows and the table doesn't content
any identity cols nor any numeric col all the varchar field. Can you
put some light on it?
Regards
ArijitHi
http://www.aspfaq.com/show.asp?id=2120
<arijitchatterjee123@.yahoo.co.in> wrote in message
news:1154433609.267834.40780@.h48g2000cwc.googlegroups.com...
> Hi Group,
> I have a question in SQL Server 2000.
> The question is, I have a table with 2 millions of records and I want
> to fetch the record from 200 to 400 rows and the table doesn't content
> any identity cols nor any numeric col all the varchar field. Can you
> put some light on it?
> Regards
> Arijit
>|||Hi
To get a number of records in a range you need to be able to order them!!!
Check out http://www.aspfaq.com/show.asp?id=2120 for various techniques that
can be used on SQLServer 7.0 and 2000. For SQL Server 2005 check out the new
ranking and TOP functionality.
John
"arijitchatterjee123@.yahoo.co.in" wrote:

> Hi Group,
> I have a question in SQL Server 2000.
> The question is, I have a table with 2 millions of records and I want
> to fetch the record from 200 to 400 rows and the table doesn't content
> any identity cols nor any numeric col all the varchar field. Can you
> put some light on it?
> Regards
> Arijit
>