John SQL Server C_1 UPDATE

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_APR_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_APR_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_AUG_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_AUG_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'ID TYPE';
END


IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_DEC_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_DEC_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_FEB_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_FEB_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JAN_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JAN_2022'
AND COLUMN_NAME = 'NAME';
END


IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUL_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUL_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_JUN_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_JUN_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'ID TYPE';
END


IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAR_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAR_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_MAY_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_MAY_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_NOV_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_NOV_2022'
AND COLUMN_NAME = 'NAME';
END


IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_OCT_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_OCT_2022'
AND COLUMN_NAME = 'NAME';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([CREATED]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'CREATED';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([ORIGIN]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'ORIGIN';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([STATUS]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'STATUS';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([ACCOUNT ID]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'ACCOUNT ID';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([MATCHES]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'MATCHES';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([ID NUMBER]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'ID NUMBER';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([ID TYPE]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'ID TYPE';
END

IF ( SELECT COUNT(*) FROM alert_ofac_SEP_2022 WHERE LEN([NAME]) = 0)  > 0
BEGIN
UPDATE validate_data SET C_1 = 0
WHERE TABLE_NAME = 'alert_ofac_SEP_2022'
AND COLUMN_NAME = 'NAME';
END