SAinCA,

this is so neat!

I too was going to reply that this is very useful for NUMBERS table for the use with matrix - like operations (read " Inside Microsoft SQL Server 7.0 " (Microsoft Press) by Ron Soukup and Karen Delaney, this book has some realy good examples, don't mind the book is for 7.0, what they say works in any version)

What I did not know is that GO (Number) will execute as many times as the number specified. I was going to run the insert in the While loop.