Urgent required !!! Fetching Particular Row

Hi,

Check out the below link

http://ehockeycoach.com/devgenuity/Articles/SQL/SQL2000Pagination.aspx

Thanks -- Vj

Hi,

James answer is correct. I will elaborate that little bit detail.

DECLARE @PageNum int
SET @PageNum = 0
SELECT TOP 5 *
FROM Product_Master
WHERE ProdID Not in
(
 SELECT TOP (@PageNum*5) ProdID
 From Product_Master
 ORDER BY ProdID
)
ORDER BY ProdID

I am considering 5 rows per page. I have 6 rows. If I have to get 1st 5 rows, send @pageNum as 0. For next 5rows, send @pageNum as 1. I can get only 1 row now. The most imporatnt part here is, "Order By" clause. You can use this inside the stored procedure. If you think that "Order By" column will be changed dynamically based on the user input, go with Dynamic SQL.

opppssss not working buddy.....Thanks for reply...More suggestion will be appreciated

as you are stuck into SQL2k you have to use something like this here (getting the thrid row)

SELECT TOP 1 *
FROM SomeTable
WHERE SomeKey Not in
(
 SELECT TOP 2 SomeKey 
 From SomeTable
)

//say ur someteble=employee and somekey=emp_int_id;