UPDATE your_table_name SET drug_exposure_end_date = DATEADD(DAY, 29, drug_exposure_start_datetime) WHERE drug_exposure_end_date IS NULL AND drug_exposure_end_datetime IS NULL AND days_supply IS NULL;