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
);
|