如何实现SQL Server 2005快速web分页

CREATE PROCEDURE usp_SalesRecords
(
      @PageSize FLOAT,
      @TargetPage SMALLINT
)
AS
BEGIN
      WITH Sales_CTE(PageNumber, SaleID, Product, SaleDate, SalePrice)
      AS
      (
SELECT
CEILING((ROW_NUMBER() OVER (ORDER BY SaleDate ASC))/@PageSize) AS PageNumber, SaleID, Product, SaleDate, SalePrice
FROM SalesHistory FROM SalesHistory
      )

      SELECT
            PageNumber, SaleID, Product, SaleDate, SalePrice
      FROM
            Sales_CTE
      WHERE
            PageNumber = @Targetpage
ENDCREATE PROCEDURE usp_SalesRecords
(
      @PageSize FLOAT,
      @TargetPage SMALLINT
)
AS
BEGIN
      WITH Sales_CTE(PageNumber, SaleID, Product, SaleDate, SalePrice)
      AS
      (
SELECT
CEILING((ROW_NUMBER() OVER (ORDER BY SaleDate ASC))/@PageSize) AS PageNumber, SaleID, Product, SaleDate, SalePrice
FROM SalesHistory FROM SalesHistory
      )

      SELECT
            PageNumber, SaleID, Product, SaleDate, SalePrice
      FROM
            Sales_CTE
      WHERE
            PageNumber = @Targetpage
END