• Nice article...

    Using tally( or numbers table) is best way..Easy to code :).

    GulliMeel

    Finding top n Worst Performing queries[/url]
    Improve the performance of Merge Join(special case)
    How to Post Performance Problem -Gail Shaw[/url]