/* Created by free online sql formatter */

DECLARE  @MyTableVar  TABLE(
                            empid            INT    NOT NULL,
                            oldvacationhours INT,
                            newvacationhours INT,
                            modifieddate     DATETIME
                            );

UPDATE TOP ( 10 ) humanresources.employee
SET    vacationhours = vacationhours * 1.25
OUTPUT inserted.employeeid, deleted.vacationhours, inserted.vacationhours, inserted.modifieddate INTO @MyTableVar;