I am so happy right now. Thanks so very much to both/all of you. My brain is no longer stuck in a do loop. I appreciate the help!!

Wow, thanks. Yes, you understand it perfectly. It would be the 2nd version (I think) - for IDs 1 through 7, it would be 7 days positive (YES) result. For...

I think you need this?

UPDATE {TABLE}

SET {COLUMN1}=CASE WHEN {COLUMN1} IS NULL THEN {something something}

END

Repeat case statement for all applicable columns