The point at which I think that the stored procedure statement fails is about here:

 print 'UPDATE ICD_specifications_for_disease_ICD_9_ICD_10_calc_spec S
+ET ICD_end_adjusted';
 UPDATE ICD_specifications_for_disease_ICD_9_ICD_10_calc_spec SET ICD_
+end_adjusted = (ICD_end + '9') FROM ICD_specifications_for_disease_IC
+D_9_ICD_10_calc_spec;


 if exists(select 1 from INFORMATION_SCHEMA.tables where table_name = 
+'Geo_mortality_count') begin raiserror ('Concurrent database access e
+rror',1,1); GOTO start; end 

 CREATE TABLE Geo_mortality_count (
    Key_m INT IDENTITY,
    Cause VARCHAR(30) NULL,
    ICD INT NOT NULL,
    Output_Area VARCHAR(20) NULL,
    Sex NUMERIC NOT NULL,
    Age_start INT NULL,
    Age_end INT NULL,
    Age_range VARCHAR(10) NULL,
    Person_count NUMERIC DEFAULT '1' NOT NULL
 );
[download]