The TallyFromTo listing posted above on 7/25/2013 does allow for negative numbers, and also allows a choice of direction. I did not check the timing, but I guarantee it is...

Here is a slightly altered version that will print results between (and including) any two integers, forward or backward. I also included the row number, since it is often useful.

...

In the original posting, the query should be

SELECT @listValues = ISNULL( @listValues + @delimeter,'') +

ISNULL(FirstName,'')

...

If the birthday is being recorded to support birthday event planning, where the year (age) may be "sensitive" to some, then you can use a datetime field, setting the year to...

You can pass the table name as an argument to the lower SP.

In the calling SP -

create table dbo.#temp (resultField int)

exec dbo.calledSP @dataValue, 'dbo.#temp' 

select * from dbo.#temp

The called procedure -

CREATE PROCEDURE dbo.calledSP...