does anyone know of a Query that will return the first TOP 10 and then
the following TOP 10 in increments fof 10??
I have 2 QUERIES which will return the first TOP 10, but not the next
increments of 10.
Here are 2 QUERIEs I am using just to return the TOP 10:
SET ROWCOUNT 10
ORDER BY contact_id asc
SELECT top 10 contact6_Id
ORDER BY contact_id ASC
These both work, but can't figure out how to get the next increments
3) also tried this a suggested, but it returns bottom 10 --not what I
SELECT TOP 10 contact_id
WHERE contact_id in
(SELECT TOP 20 contact_id