/* 
This script will create a table of table names and the amount of rows that are encountered in 
each table. It will also display the minimum and maximum year from all data tables wth year information.

To use the script:
1. Change the Line USE [Summary Tables] to the name of your summary table database.
2. After executing, check the "messages" tab; it will note any Table and Column that is missing from your database. 

If the database is configured properly you will see "PASS Column Check Test" in the Messages. 

If any tables or columns are missing, make required changes and re-run the query.
*/

 -----Modify Query Paramaters Below------

 USE 'Desired Database Name'

GO
-------Do not modify anything below this line--------------------


DECLARE @did_test_pass varchar(50);
SET @did_test_pass = 'PASSED column check test. :)';

   IF OBJECT_ID(N'AGE_GROUPS', N'U') IS NULL
BEGIN
    PRINT 'Table AGE_GROUPS Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'id') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN ID Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat10_name') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat10_name Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat10_sort_order') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat10_sort_order Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat2_name') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat2_name Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat2_sort_order') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat2_sort_order Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat4_name') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat4_name Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat4_sort_order') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat4_sort_order Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat7_name') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat7_name Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.AGE_GROUPS', 'strat7_sort_order') IS NULL
BEGIN
	PRINT 'Table AGE_GROUPS COLUMN strat7_sort_order Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'age_group') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'dayssupply') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN dayssupply Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'dispensings') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN dispensings Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'drugclass') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN drugclass Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'members') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'period') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.DRUG_CLASS', 'Sex') IS NULL
BEGIN
	PRINT 'Table DRUG_CLASS COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'age_group') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'dayscovered') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN dayscovered Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'DrugCov') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN DrugCov Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'MedCov') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN MedCov Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'members') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'Sex') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ENROLLMENT', 'year') IS NULL
BEGIN
	PRINT 'Table ENROLLMENT COLUMN year Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'age_group') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'dayssupply') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN dayssupply Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'dispensings') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN dispensings Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'genericname') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN genericname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'members') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'period') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.GENERIC_NAME', 'Sex') IS NULL
BEGIN
	PRINT 'Table GENERIC_NAME COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'age_group') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'events') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'members') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'period') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'px_code') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN px_code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'pxname') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN pxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'setting') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.HCPCS', 'Sex') IS NULL
BEGIN
	PRINT 'Table HCPCS COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'age_group') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'code') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'dxname') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN dxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'events') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'members') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'period') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'setting') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS', 'Sex') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'age_group') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'code') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'dxname') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN dxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'events') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'members') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'period') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'setting') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_4_DIGIT', 'Sex') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_4_DIGIT COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'age_group') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'code') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'dxname') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN dxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'events') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'members') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'period') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'setting') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_DIAGNOSIS_5_DIGIT', 'Sex') IS NULL
BEGIN
	PRINT 'Table ICD9_DIAGNOSIS_5_DIGIT COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'age_group') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'code') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'events') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'members') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'period') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'pxname') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN pxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'setting') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE', 'Sex') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'age_group') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'events') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN events Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'members') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN members Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'period') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'px_code') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN px_code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'pxname') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN pxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'setting') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.ICD9_PROCEDURE_4_DIGIT', 'Sex') IS NULL
BEGIN
	PRINT 'Table ICD9_PROCEDURE_4_DIGIT COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'age_group') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dayssupply180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dayssupply180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dayssupply270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dayssupply270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dayssupply90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dayssupply90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dispensings180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dispensings180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dispensings270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dispensings270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Dispensings90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Dispensings90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'drugclass') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN drugclass Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Episodespan180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Episodespan180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Episodespan270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Episodespan270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Episodespan90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Episodespan90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'members180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN members180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members180Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members180Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members180Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members180Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members180Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members180Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members180Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members180Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'members270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN members270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members270Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members270Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members270Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members270Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members270Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members270Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members270Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members270Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'members90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN members90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members90Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members90Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members90Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members90Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members90Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members90Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Members90Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Members90Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'period') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_DRUG_CLASS', 'Sex') IS NULL
BEGIN
	PRINT 'Table INCIDENT_DRUG_CLASS COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'age_group') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dayssupply180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dayssupply180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dayssupply270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dayssupply270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dayssupply90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dayssupply90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dispensings180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dispensings180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dispensings270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dispensings270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Dispensings90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Dispensings90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Episodespan180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Episodespan180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Episodespan270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Episodespan270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Episodespan90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Episodespan90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'genericname') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN genericname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'members180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN members180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members180Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members180Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members180Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members180Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members180Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members180Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members180Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members180Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'members270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN members270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members270Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members270Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members270Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members270Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members270Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members270Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members270Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members270Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'members90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN members90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members90Q1') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members90Q1 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members90Q2') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members90Q2 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members90Q3') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members90Q3 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Members90Q4') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Members90Q4 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'period') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_GENERIC_NAME', 'Sex') IS NULL
BEGIN
	PRINT 'Table INCIDENT_GENERIC_NAME COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'age_group') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN age_group Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'age_group_id') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN age_group_id Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'code') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN code Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'dxname') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN dxname Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'Events180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN Events180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'Events270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN Events270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'Events90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN Events90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'members180') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN members180 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'members270') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN members270 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'members90') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN members90 Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'period') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN period Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'setting') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN setting Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END

IF COL_LENGTH('dbo.INCIDENT_ICD9_DIAGNOSIS', 'Sex') IS NULL
BEGIN
	PRINT 'Table INCIDENT_ICD9_DIAGNOSIS COLUMN Sex Does NOT Exist'
	SET @did_test_pass = 'Fail test at some point. Please read messages above.';
END




PRINT  @did_test_pass


/*BELOW will test and display the amount of members and date ranges found in the tables

NOTE: it will only run if the column check came back correct*/

if @did_test_pass like '%PASSED%'

BEGIN

DECLARE @age_members int; 
SELECT @age_members = (
select count(id)
from AGE_GROUPS
)

	 DECLARE @drug_members int;
 SELECT @drug_members  = (
select  count(members)
from    DRUG_CLASS
)

if @drug_members is null or @drug_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY DRUG_CLASS'
END

 DECLARE @drug_min varchar(50);
 SELECT @drug_min  = (
select  min(period)
from    DRUG_CLASS
)

 DECLARE @drug_max varchar(50);
 SELECT @drug_max  = (
select  max(period)
from    DRUG_CLASS
)
/*
Print 'Min Year DRUG_CLASS:  ' + @drug_min
Print 'Max Year DRUG_CLASS:  ' + @drug_max
*/
/*################################################################################*/
 DECLARE @enroll_members int;
 SELECT @enroll_members  = (
select  count(members)
from    Enrollment
)

if @enroll_members is null or @enroll_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ENROLLMENT'
END

 DECLARE @enroll_min varchar(50);
 SELECT @enroll_min  = (
select  min(year)
from    ENROLLMENT
)

 DECLARE @enroll_max varchar(50);
 SELECT @enroll_max  = (
select  max(year)
from    ENROLLMENT
)
/*
Print 'Min Year ENROLLMENT:  ' + @enroll_min
Print 'Max Year ENROLLMENT:  ' + @enroll_max
*/
/*################################################################################*/

 DECLARE @gen_members int;
 SELECT @gen_members  = (
select  count(members)
from    GENERIC_NAME
)

if @gen_members is null or @gen_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY GENERIC_NAME'
END

 DECLARE @gen_min varchar(50);
 SELECT @gen_min  = (
select  min(period)
from    GENERIC_NAME
)

 DECLARE @gen_max varchar(50);
 SELECT @gen_max  = (
select  max(period)
from    GENERIC_NAME
)
/*
Print 'Min Year GENERIC_NAME:  ' + @gen_min
Print 'Max Year GENERIC_NAME:  ' + @gen_max
*/
/*################################################################################*/

 DECLARE @hcpcs_members int;
 SELECT @hcpcs_members  = (
select  count(members)
from    HCPCS
)

if @hcpcs_members is null or @hcpcs_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY HCPCS'
END

 DECLARE @hc_min varchar(50);
 SELECT @hc_min  = (
select  min(period)
from   HCPCS
)

 DECLARE @hc_max varchar(50);
 SELECT @hc_max  = (
select  max(period)
from    HCPCS
)
/*
Print 'Min Year HCPCS:  ' + @hc_min
Print 'Max Year HCPCS:  ' + @hc_max
*/
/*################################################################################*/

 DECLARE @icd_members int;
 SELECT @icd_members  = (
select  count(members)
from    ICD9_DIAGNOSIS
)

if @icd_members is null or @icd_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_DIAGNOSIS'
END

 DECLARE @icd_min varchar(50);
 SELECT @icd_min  = (
select  min(period)
from    ICD9_DIAGNOSIS
)

 DECLARE @icd_max varchar(50);
 SELECT @icd_max  = (
select  max(period)
from    ICD9_DIAGNOSIS
)
/*
Print 'Min Year ICD9_DIAGNOSIS:  ' + @icd_min
Print 'Max Year ICD9_DIAGNOSIS:  ' + @icd_max
*/



/*################################################################################*/

 DECLARE @icd4_members int;
 SELECT @icd4_members  = (
select  count(members)
from    ICD9_DIAGNOSIS_4_DIGIT
)

if @icd4_members is null or @icd4_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_DIAGNOSIS_4_DIGIT'
END

 DECLARE @icd4_min varchar(50);
 SELECT @icd4_min  = (
select  min(period)
from    ICD9_DIAGNOSIS_4_DIGIT
)

 DECLARE @icd4_max varchar(50);
 SELECT @icd4_max  = (
select  max(period)
from    ICD9_DIAGNOSIS_4_DIGIT
)
/*
Print 'Min Year ICD9_DIAGNOSIS_4_DIGIT:  ' + @icd4_min
Print 'Max Year ICD9_DIAGNOSIS_4_DIGIT:  ' + @icd4_max
*/


/*################################################################################*/
 DECLARE @icd5_members int;
 SELECT @icd5_members  = (
select  count(members)
from    ICD9_DIAGNOSIS_5_DIGIT
)

if @icd5_members is null or @icd5_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_DIAGNOSIS_5_DIGIT'
END

 DECLARE @icd5_min varchar(50);
 SELECT @icd5_min  = (
select  min(period)
from    ICD9_DIAGNOSIS_5_DIGIT
)

 DECLARE @icd5_max varchar(50);
 SELECT @icd5_max  = (
select  max(period)
from    ICD9_DIAGNOSIS_5_DIGIT
)
/*
Print 'Min Year ICD9_DIAGNOSIS_5_DIGIT:  ' + @icd5_min
Print 'Max Year ICD9_DIAGNOSIS_5_DIGIT:  ' + @icd5_max
*/

/*################################################################################*/


 DECLARE @icdp_members int;
 SELECT @icdp_members  = (
select  count(members)
from    ICD9_PROCEDURE
)

if @icd_members is null or @icd_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_PROCEDURE'
END

 DECLARE @icdp_min varchar(50);
 SELECT @icdp_min  = (
select  min(period)
from    ICD9_PROCEDURE
)

 DECLARE @icdp_max varchar(50);
 SELECT @icdp_max  = (
select  max(period)
from    ICD9_PROCEDURE
)
/*
Print 'Min Year ICD9_PROCEDURE:  ' + @icdp_min
Print 'Max Year ICD9_PROCEDURE:  ' + @icdp_max
*/
/*################################################################################*/

 DECLARE @icdp4_members int;
 SELECT @icdp4_members  = (
select  count(members)
from    ICD9_PROCEDURE_4_DIGIT
)

if @icd_members is null or @icd_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_PROCEDURE_4_DIGIT'
END

 DECLARE @icdp4_min varchar(50);
 SELECT @icdp4_min  = (
select  min(period)
from    ICD9_PROCEDURE_4_DIGIT
)

 DECLARE @icdp4_max varchar(50);
 SELECT @icdp4_max  = (
select  max(period)
from    ICD9_PROCEDURE_4_DIGIT
)
/*
Print 'Min Year ICD9_PROCEDURE_4_DIGIT:  ' + @icdp4_min
Print 'Max Year ICD9_PROCEDURE_4_DIGIT:  ' + @icdp4_max
*/
/*################################################################################*/

 DECLARE @icdpdc_members int;
 SELECT @icdpdc_members  = (
select  count(members90)
from    INCIDENT_DRUG_CLASS
)

if @icdpdc_members is null or @icdpdc_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY ICD9_PROCEDURE'
END

 DECLARE @icdpdc_min varchar(50);
 SELECT @icdpdc_min  = (
select  min(period)
from    INCIDENT_DRUG_CLASS
)

 DECLARE @icdpdc_max varchar(50);
 SELECT @icdpdc_max  = (
select  max(period)
from    INCIDENT_DRUG_CLASS
)
/*
Print 'Min Year INCIDENCE_DRUG_CLASS:  ' + @icdpdc_min
Print 'Max Year INCIDENCE_DRUG_CLASS:  ' + @icdpdc_max
*/
/*################################################################################*/

 DECLARE @incg_members int;
 SELECT @incg_members  = (
select  count(members90)
from    INCIDENT_GENERIC_NAME
)

if @incg_members is null or @incg_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY INCIDENT_GENERIC_NAME'
END

 DECLARE @incg_min varchar(50);
 SELECT @incg_min  = (
select  min(period)
from    INCIDENT_GENERIC_NAME
)

 DECLARE @incg_max varchar(50);
 SELECT @incg_max  = (
select  max(period)
from    INCIDENT_GENERIC_NAME
)
/*
Print 'Min Year INCIDENCE_GENERIC_NAME:  ' + @incg_min
Print 'Max Year INCIDENCE_GENERIC_NAME:  ' + @incg_max
*/
/*################################################################################*/

 DECLARE @inc9_members int;
 SELECT @inc9_members  = (
select  count(members90)
from    INCIDENT_ICD9_DIAGNOSIS
)

if @inc9_members is null or @inc9_members = 0 
BEGIN
	Print 'DATA NOT LOADED PROPERLY INCIDENT_ICD9_DIAGNOSIS'
END

 DECLARE @inc9_min varchar(50);
 SELECT @inc9_min  = (
select  min(period)
from    INCIDENT_ICD9_DIAGNOSIS
)

 DECLARE @inc9_max varchar(50);
 SELECT @inc9_max  = (
select  max(period)
from    INCIDENT_ICD9_DIAGNOSIS
)
/*
Print 'Min Year INCIDENT_ICD9_DIAGNOSIS:  ' + @inc9_min
Print 'Max Year INCIDENT_ICD9_DIAGNOSIS:  ' + @inc9_max
*/

/*
select
schema_name(obj.schema_id) + '.' + obj.name,
row_count
from (
    select
        object_id,
        row_count = sum(row_count)
    from sys.dm_db_partition_stats
    where index_id < 2  -- heap or clustered index
    group by object_id
) Q
join sys.tables obj on obj.object_id = Q.object_id
*/

DECLARE @placeholder varchar(50);
Select @placeholder  = NULL


declare @min_year_total table(Table_name varchar(50), row_count int, min_year varchar(50), max_year varchar(50))
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('AGE_GROUPS', @age_members, @placeholder, @placeholder) /*AGE_GROUPS*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('DRUG_CLASS', @drug_members, @drug_min, @drug_max) /*DRUG_CLASS*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ENROLLMENT', @enroll_members, @enroll_min, @enroll_max) /*ENROLLMENT*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('GENERIC_NAME', @gen_members, @gen_min, @gen_max) /*GENERIC_NAME*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('HCPCS', @hcpcs_members, @hc_min, @hc_max) /*HCPCS*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ICD9_DIAGNOSIS', @icd_members, @icd_min, @icd_max) /*ICD9_DIAGNOSIS*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ICD9_DIAGNOSIS_4_DIGIT', @icd4_members, @icd4_min, @icd4_max) /*ICD9_DIAGNOSIS_4_DIGIT*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ICD9_DIAGNOSIS_5_DIGIT', @icd5_members, @icd5_min, @icd5_max) /*ICD9_DIAGNOSIS_5_DIGIT*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ICD9_PROCEDURE', @icdp_members, @icdp_min, @icdp_max) /*ICD9_PROCEDURE*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('ICD9_PROCEDURE_4_DIGIT', @icdp4_members, @icdp4_min, @icdp4_max) /*ICD9_PROCEDURE_4_DIGIT*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('INCIDENT_DRUG_CLASS', @icdpdc_members, @icdpdc_min, @icdpdc_max) /*INCIDENT_DRUG_CLASS*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('INCIDENT_GENERIC_NAME', @incg_members, @incg_min, @incg_max) /*INCIDENT_GENERIC_NAME*/
insert into @min_year_total (Table_name, row_count, min_year, max_year) values ('INCIDENT_ICD9_DIAGNOSIS', @inc9_members, @inc9_min, @inc9_max) /*INCIDENT_ICD9_DIAGNOSIS*/




SELECT * from @min_year_total

END
ELSE
BEGIN
	PRINT 'PLEASE MAKE EDITS AND RERUN SCRIPT'
END