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_SelectViewByGuid_ParentCustomerID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
		DROP PROCEDURE [dbo].[PR_MST_Customer_SelectViewByGuid_ParentCustomerID]
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_SelectViewByGuid_ParentCustomerID] @ParentCustomerID = '00000000-0000-0000-0000-000000000000'

CREATE PROCEDURE [dbo].[PR_MST_Customer_SelectViewByGuid_ParentCustomerID]

		@ParentCustomerID 		uniqueidentifier

/*
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
*/

SELECT  
		[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]

WHERE [dbo].[MST_Customer].[ParentCustomerID] = @ParentCustomerID

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