Paging in SQL

Question

I have a SELECT that needs to turn into a PROC with paging to be consumed by an ASP (classic) page. Could you help me?

Below is the SELECT:

SELECT
A.NOMUSU,
A.NOMMAE,
C.ATIVID,
B.DSCEND,
B.NUMEND,
B.DSCBAI,
B.DSCCID,
B.CODUFE,
B.CODCEP,
D.NUMDDD,
D.NUMTEL
FROM TBCADUSU A
INNER JOIN TBCADEND B ON (A.CODUSU = B.CODUSU)
INNER JOIN TBCADCRE C ON (A.CODUSU = C.CODUSU)
INNER JOIN TBCADCTO D ON (A.CODUSU = D.CODUSU)
WHERE B.TIPEND = 2