DECLARE @COUNTER NUMERIC SELECT @COUNTER = 1 WHILE (@COUNTER <5) BEGIN SELECT @COUNTER = @COUNTER +1 END