Rob Fisk (9/22/2009)
I agree. Definitely an interesting article but I would have liked to see tests against an already created and indexed tally table and the reasons for going dynamic rather than static since it is quite easy to sort and scale results to any interval/order from a static table.I'll have a look myself of course but for now cannot thing of a reason to use a function over a static tally table. Maybe I'm missing something though.
I can't tell you the number of times a tally or numbers table approach has been suggested to someone on the forums here and the response was something to the affect of "I'm not allowed to change the schema" or "I can't get a static table like that approved." Seems like a quick way to dynamically generate a tally table of just the numbers you need would be very helpful in those circumstances...
Good thorough description of the code Lynn, and a good read.
Thanks,
-Luke.