USE ION_Data
Declare @CurrentDateTime varchar ( max )
SET @CurrentDateTime = GETUTCDATE ()
INSERT  INTO EventAcknowledgement (EventLogID ,AckTimeUTC ,UserName )
( SELECT a .ID , @CurrentDateTime , 'supervisor' from vAlarmLog a where AckTimeUTC is  null) 