Amend script - continue on duplicate?

Hi,

I have a script that inserts data in to a table based on the query run prior to the insert. The script is brilliant and works perfectly but I would like to amend it so it will continue if there is already a record in the system the same as the one being entered.

The script is attached, I got it from here in the first place but it's beyond me to amend it with my knowledge.

Any help would be much appreciated.

Best Regards,

Ken
 

begin
SET NOCOUNT ON
--adjust to make the COL refs predictably 2 char
set @start = upper(case when @start like '[A-Z][0-99]%' then '@' else '' end +@start)
set @end = upper(case when @end like '[A-Z][0-99]%' then '@' else '' end +@end)
SET NOCOUNT OFF

-- this inserts into table named "Grid"
insert blockdirectory (countryCode ,cityCode ,storeCode ,storeType , gridCodeX , gridCodeY)

select @countryCode, @cityCode, @storeCode, @storeType, REPLACE(COL,'@','') + right(ROW,2), REPLACE(COL,'@','') + right(ROW,2)
from
(
	-- this inner query generates all the references from @A1 through ZZ99
	-- the @ is a placeholder for single-letter columns
	select
		char(a.number)+coalesce(char(b.number),'') as COL
		,d.number as ROW
	from master..spt_values a
	left join master..spt_values b on b.type='P' and b.number between 65 and 90
	inner join master..spt_values d on d.type='P' and d.number between 1 and 99
	where a.type='P' and a.number between 64 and 90
) F

-- filter for the range of COL/ROW required
where COL between left(@start,2) and left(@end,2)
and ROW between substring(@start,3,3) and substring(@end,3,3)


update blockdirectory
set dmsActive = 'False'
Where dmsActive IS NULL
end

Select allOpen in new window