set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [atomic].[proc_insert_update_PAR_Field_Hockey_Experience_Information_ExcelUpload]
(
	@Years_On_Varsity			int,
	@Years_As_Varsity_Starter	int,
	@Camps_Attended				varchar(50),
	@Player_ID					varchar(32)
)
AS
Begin

	DECLARE @updateQuery varchar(1000)
	
	DECLARE @insertQuery varchar(1000)
		
	SET @updateQuery  = 'UPDATE	PAR_Field_Hockey_Experience_Information SET '
	IF @Player_ID IS NOT NULL
	BEGIN
		SET @updateQuery  = @updateQuery +'Player_ID = @Player_ID, '
	END
	IF @Years_On_Varsity IS NOT NULL
	BEGIN
		SET @updateQuery  = @updateQuery +'Years_On_Varsity = @Years_On_Varsity, '
	END
	IF @Years_As_Varsity_Starter IS NOT NULL
	BEGIN
		SET @updateQuery  = @updateQuery +'Years_As_Varsity_Starter	= @Years_As_Varsity_Starter, '
	END		
	IF @Camps_Attended IS NOT NULL
	BEGIN
		SET @updateQuery  = @updateQuery +'Camps_Attended = @Camps_Attended '
	END			
	SET @updateQuery  = @updateQuery +'WHERE Player_ID = @Player_ID '
	
	EXEC @updateQuery