Home Forums Article Discussions Article Discussions by Author Discuss content posted by Adam Aspin Using a CTE as a Tally Table RE: Using a CTE as a Tally Table

  • August 9, 2018 at 5:07 am

    #2000987

    Eirikur Eiriksson - Thursday, August 9, 2018 2:47 AM

    Be careful here, the recursive CTE is much slower than the inline tally table CTE method I posted, strongly advice against using a recursive CTE for this purpose.
    😎

    Agreed, it doesn't scale upwards, 10,000 is slower with a recursive cte.
    But no difference for 52 (or 53)
    I'll keep yours in mind, never seen it before.