Following procedure used to get Customers Details with Paging.
Create procedure GetCustomersWithPaging
@PageSize INT, --No of Records per Page
@PageNumber INT--selected Page Number
AS
begin
set nocount on
Declare @FirstRow INT
Declare @LastRow INT
SELECT @FirstRow = ( @PageNumber - 1) * @PageSize + 1,
@LastRow = (@PageNumber - 1) * @PageSize + @PageSize ;
WITH Members AS
(
SELECT CustomerID,ContactName,Address,
ROW_NUMBER() OVER (ORDER BY CustomerID DESC) AS RowNumber
FROM Customers
)
SELECT RowNumber,CustomerID,ContactName,Address
FROM Members
WHERE RowNumber BETWEEN @FirstRow AND @LastRow
ORDER BY RowNumber ASC;
end
GO
Solution for the QlikView, Biztalk, DotNet and MSBI real time development problems
Search This Blog
Friday, November 28, 2008
Subscribe to:
Posts (Atom)
Popular Posts
-
Migration from Visual Studio 2008 to 2013 Without any code changes I successfully migrated from VS 2008 to 2013 but when running website f...
-
I am getting below error while executing stored procedure from C# (Ado.net, entity framework) String[2]: the Size property has an invalid ...
-
Exception : Microsoft.WindowsAzure.StorageClient.StorageClientException was unhandled Message=One of the request inputs is out of ran...
-
as is Is Operator is used to check the Compatibility of an Object with a given Type and it returns the result as a Boolean (True or ...
-
Review the permissions of the user that you're trying to impersonate. In my situation, I was only getting the error on my development ...