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 --~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~