print 'UPDATE ICD_specifications_for_disease_ICD_9_ICD_10_calc_spec SET 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_ICD_9_ICD_10_calc_spec;


 if exists(select 1 from INFORMATION_SCHEMA.tables where table_name = 'Geo_mortality_count') begin raiserror ('Concurrent database access error',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
 );