Tuesday, 14 November 2017

Paging store Procedure to increase the performance data loading

DECLARE @PageNum AS INT;
DECLARE @PageSize AS INT;
SET @PageNum = 2;
SET @PageSize = 10;

WITH OrdersRN AS
(
    SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, OrderID) AS RowNum
          ,OrderID
          ,OrderDate
          ,CustomerID
          ,EmployeeID
      FROM dbo.Orders
)

SELECT * 
  FROM OrdersRN
 WHERE RowNum BETWEEN (@PageNum - 1) * @PageSize + 1 
                  AND @PageNum * @PageSize
 ORDER BY OrderDate
         ,OrderID;

No comments:

Post a Comment

How to convert plugin assembly (dll) into base 64 bytes using console application (C#).

 using System; using System.IO; using System.ServiceModel.Description; using Microsoft.Rest; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sd...