Jeff,

here is a Google link to a copy of this book:

http://books.google.ca/books?id=JR3cOHQ8LMAC&dq=transact+sql+cookbook&printsec=frontcover&source=bn&hl=en&ei=qq7AStbFKMGe8AbAyqW4AQ&sa=X&oi=book_result&ct=result&resnum=4#v=onepage&q=&f=false

Have a good day

Greg

Jeff, great job, I like your articles.

I have discovered the Tally concept reading the Transact-SQL by Ales Spetic & Jonathan Gennick. They call it Pivot.

I think that...

declare @int table (n char(1))

insert @int

select '0'

union select '1'

union select '2'

union select '3'

union select '4'

union select '5'

union select '6'

union select '7'

union select '8'

union select '9'

insert util_nums

select convert(int,n1.n + n2.n...