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;
Tuesday, 14 November 2017
Paging store Procedure to increase the performance data loading
Subscribe to:
Posts (Atom)
Dynamics 365 Ribbon Button JavaScript customization function- Displays a popup message when the button is clicked.
function RequestRibbonCustomisation(primaryControl) { var formContext = primaryControl; alert("Coming soon! Work in Progress....
-
CREATE Procedure SP_PaymentToSupplierEmployee_Periodically @tbl_OrganizationId nvarchar(50) AS BEGIN SET NOCOUNT ON; SELECT COUNT(...
-
CRM does not allow direct download of the DLL file from the UI . However, there are several ways to retrieve the plugin DLL from the CRM e...
-
var It is introduced C#3.0 Version. dynamic It is introduced C# 4.0 version 1).Var is statically type of variable, where are dyna...