Bunch Of 5 Rows

Hi All,
I have a case in which i have to get the bunch of 5 rows at a time
from database, It could be taken in stored procedure also.
i would like to tell you how should i get results. I
have total 40 rows in my table, if i execute Stored procedure first time, i
should get first 5 rows, second time i should get second 5 rows so and so
for. This way i have to execute this stored procedure 8 times sothat i could
get all 40 rows.
If anybody have solution, plz
help mehttp://www.aspfaq.com/show.asp?id=2120
David Portas
SQL Server MVP
--|||Hi David
I got to know that this is asp code, i want it to all this work
in SQL server only, can @.@.cursor_rows help me?
"David Portas" wrote:

> http://www.aspfaq.com/show.asp?id=2120
> --
> David Portas
> SQL Server MVP
> --
>|||Why would you use a cursor? The ASPFAQ article proposes several
solutions - none of them requires a server-side cursor.
David Portas
SQL Server MVP
--|||On Thu, 11 Aug 2005 22:01:02 -0700, Manish wrote:
>Hi David
> I got to know that this is asp code, i want it to all this work
>in SQL server only, can @.@.cursor_rows help me?
>"David Portas" wrote:
>
Hi Manish,
Visit that URL again. The first few solutions are ASP, but further down
are some SQL Server ways.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)