You're right, peter_budo. I should have posted the code first time around. Anyway, here it is now

DECLARE @VisitType varchar(7) --The Visit Name with which tblWindows is to be updated

--DECLARE...