
DECLARE @ReportID BIGINT = 1395
	, @SuggestedItemFilterParameterTypeEnum BIGINT = 410

IF NOT EXISTS(SELECT 1 FROM [dbo].[tbReportParameter] WHERE ReportID = @ReportID AND ParameterTypeEnum = @SuggestedItemFilterParameterTypeEnum)
BEGIN
	
	INSERT INTO [dbo].[tbReportParameter] (ReportID, ParameterTypeEnum, Name, IsRequired )
	VALUES (@ReportID, @SuggestedItemFilterParameterTypeEnum, 'Suggested Item Filter', 0)

END
GO

DECLARE @ReportID BIGINT = 1395
	, @MultipleItemIDsEnum BIGINT = 189
	, @MutlipleSuggestedItemIDsEnum BIGINT = -3

IF EXISTS(SELECT 1 FROM [dbo].[tbReportParameter] WHERE ReportID = @ReportID AND ParameterTypeEnum = @MultipleItemIDsEnum)
BEGIN
	
	UPDATE [dbo].[tbReportParameter]
	SET  ParameterTypeEnum = @MutlipleSuggestedItemIDsEnum
	WHERE ReportID = @ReportID
	AND ParameterTypeEnum = @MultipleItemIDsEnum

END
GO
