USE [Customer]
GO
/*
This is SP Begining Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.sysobjects WHERE id = object_id(N'[dbo].[PR_MST_Customer_SelectPaging]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
		DROP PROCEDURE [dbo].[PR_MST_Customer_SelectPaging]
END
GO

/*
-- =============================================
-- Author 	  : Tools4SQL.net - T4S Stored Procedure Generator
-- Create date: 01-March-2011
-- Description:	This stored procedure is generated by T4S Stored Procedure Generator.
-- =============================================
*/

--   [dbo].[PR_MST_Customer_SelectPaging] @PageIndex = 1, @PageSize = 1

CREATE PROCEDURE [dbo].[PR_MST_Customer_SelectPaging]

		@PageIndex 		int,
		@PageSize  		int

/*
This is SP Parameter Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

AS

SET NOCOUNT ON;

/*
This is SP Body Comment generated from Tools4SQL.net - T4S Stored Procedure Generator.
Website : http://www.tools4sql.net
Email : info@tools4sql.net
*/

DECLARE @StartIndex INT, @EndIndex INT

SET	@PageIndex = @PageIndex - 1
SET   @StartIndex = (@PageIndex * @PageSize) + 1
SET   @EndIndex = @StartIndex + @PageSize - 1

;WITH PagingTable AS
(
		SELECT  
				ROW_NUMBER() OVER ( ORDER BY [dbo].[MST_Customer].[CustomerName] ) AS [RowNumber],
				[dbo].[MST_Customer].[CustomerID],
				[dbo].[MST_Customer].[CustomerSerialNo],
				[dbo].[MST_Customer].[CustomerName] AS [MST_Customer_CustomerName],
				[dbo].[MST_Customer].[ParentCustomerID],
				[ParentCustomerID_MST_Customer].[CustomerName] AS [ParentCustomerID_MST_Customer_CustomerName],
				[dbo].[MST_Customer].[AddressLine1],
				[dbo].[MST_Customer].[AddressLine2],
				[dbo].[MST_Customer].[AddressLine3],
				[dbo].[MST_Customer].[CityID],
				[dbo].[MST_City].[CityName],
				[dbo].[MST_Customer].[PhoneNo],
				[dbo].[MST_Customer].[MobileNo],
				[dbo].[MST_Customer].[FaxNo],
				[dbo].[MST_Customer].[Email],
				[dbo].[MST_Customer].[Website],
				[dbo].[MST_Customer].[Remarks],
				[dbo].[MST_Customer].[IsActive],
				[dbo].[MST_Customer].[ModifiedDate],
				[dbo].[MST_Customer].[CreatedDate]
		FROM  [dbo].[MST_Customer]
		INNER JOIN [dbo].[MST_City]
		ON [dbo].[MST_Customer].[CityID] = [dbo].[MST_City].[CityID]
		LEFT OUTER JOIN [dbo].[MST_Customer] AS [ParentCustomerID_MST_Customer]
		ON [dbo].[MST_Customer].[ParentCustomerID] = [ParentCustomerID_MST_Customer].[CustomerID]
		
)

SELECT * FROM PagingTable
WHERE RowNumber Between @StartIndex AND @EndIndex

GO
--~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~