这样的Sql查询语句如何改成分页语句呢？麻烦高手帮我处理下，谢谢

select distinct CouponList.Company,CouponList.CustID from CustomerAddressBook,CouponList where CustomerAddressBook.CustID=CouponList.CustID

Company这个字段是有重复的记录的
麻烦高手帮我处理下，谢谢

ALTER PROC [dbo].[myx_prPageRecordset]
@queryStr nvarchar(1000), --sql语句如：* From users order by id asc
@keyField nvarchar (200), --主键
@pageSize int, --页面显示记录数
@pageNumber int -- 当前页面（首页为0)
--说明：
--@queryStr = N'id,username From users order by id asc',
--@keyField = N'id',
--@pageSize = 5,
--@pageNumber =0
AS
BEGIN
DECLARE @sqlText AS nvarchar(4000) --sql语句
DECLARE @sqlTable AS nvarchar(4000)--sql语句
SET @sqlTable = 'SELECT TOP ' + CAST((@pageNumber + 1) * @pageSize AS varchar(30)) + ' ' + @queryStr
SET @sqlText =
'SELECT TOP ' + CAST(@pageSize AS varchar(30)) + ' * ' +
'FROM (' + @sqlTable + ') AS tableA ' +
'WHERE ' + @keyField + ' NOT IN(SELECT TOP ' +
CAST(@pageNumber * @pageSize AS varchar(30)) + ' ' + @keyField +
' FROM (' + @sqlTable + ') AS tableB)'