Miscellany

IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_ECIX_DisplayQuery')	BEGIN		DROP  Procedure  [dbo].[usp_ECIX_DisplayQuery]	ENDGOCREATE Procedure dbo.usp_ECIX_DisplayQuery	(		@ID varchar(100)	)ASSELECT     [Customer First Name] + ', ' + [Customer Last Name] AS Display1, MRN AS Display2, Campus AS Display3, Unit AS Display4,                       [Customer ID] AS Display5FROM         [bam_Customer View_ViewCustomerActivity_View]WHERE     ([Customer ID] = @ID)GO