I have a TSQL stored procedure that does an UPDATE to a table where certain criteria must be matched. This updates a "ProcessDate" to GETDATE(). However, all unmatched data never gets this ProcessDate updated (since there was no match it stays a NULL). Is there a way to update the ProcessDate on the records that do not match at the same time? My current solution would be to simply add an additional UPDATE statement after the first one runs to go back and update all ProcessDate = NULL to GETDATE(), but wasn't sure if there was a better way of doing this or not? Thank you.