IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_ECIX_DisplayQuery')
	BEGIN
		DROP  Procedure  [dbo].[usp_ECIX_DisplayQuery]
	END

GO

CREATE Procedure dbo.usp_ECIX_DisplayQuery
	(
		@ID varchar(100)
	)
AS

SELECT     [Customer First Name] + ', ' + [Customer Last Name] AS Display1, MRN AS Display2, Campus AS Display3, Unit AS Display4, 
                      [Customer ID] AS Display5
FROM         [bam_Customer View_ViewCustomerActivity_View]
WHERE     ([Customer ID] = @ID)

GO