>>>DECLARE @Test TABLE (Fld1 datetime, Fld2 datetime) >>>DECLARE @i int >>>SET @i = 0 >>>WHILE @i < 20 >>> BEGIN >>> INSERT INTO @Test VALUES (GETDATE()+@i, GETDATE()+@i*20) >>> SET @i = @i +1 >>> END >>>SELECT SUM(Fld2-Fld2) FROM @Test >>>