• Karthick,

    Jeff was making valid point about about how to create the Tally table in the first place, most people will write a while loop, or a recursive CTE rather than using a cross join between two of the sys tables in the db.

    I suspect Jeff wants to see the developer do the cross join rather than the CTE or a While loop. 😀

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices