Select Specific Number Of Records

Dear Group

I wonder whether you can give me a syntax example for a SQL Statement.

Lets assume I've a table containing three columns ContactID (Primary Key),
Firstname and Lastname.

I would like to write a stored procedure which returns me the first ten
records and increments an outside variable each time it runs.
E.g If I run it the first time I pass the variable as 0 and it will return
me the first ten records and returns the variable value 1.
When run a second time, I will pass the variable as 1 and it will return me
records 11-20 and sets the variable to 2 and so on...

The difficult thing is how to tell to return me records 11-20. I can't use
the ContactID as someone might have deleted a row and e.g. ContactID 18 is
missing. In this case I only would get 9 rows returned. It always should be
ten.

Thanks very much for your time and efforts!

Kind Regards,

Martin

"There are 10 types of people in this world: Those that understand binary
arithmetic, and those that don't."