Listing 1:

CREATE FUNCTION dbo.udfGetSequence
   (@A int,
    @Z int)
RETURNS @T TABLE (Number int)
AS
BEGIN

DECLARE @I int

SET @I = 1

INSERT @T VALUES (@A)

WHILE @I < @Z - @A + 1

    BEGIN

    INSERT @T
    SELECT @I + Number
      FROM @T
     WHERE @I + Number <= @Z

    SET @I = @I + @@ROWCOUNT

    END

RETURN
END 