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:
Post Comments (Atom)
Popular Posts
-
The typical way of testing WCF services is to create a test project, add a service reference to the project, and then write a test agains...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
@foreach (var item in Model), Object reference not set to an instance of an object in MVC Razor ViewIndex.cshtml @model IEnumerable <RazorEngineMVC.Models. User > @{ ViewBag.Title = "Index" ; } < h2 &...
-
By default using the LINQ to SQL DataContext design surface (or the SQL Metal command line tool), all parameters are created for a Stored Pr...
No comments:
Post a Comment