Home Forums SQL Server 7,2000 T-SQL Interesting problem for the "Running Total/Quirky Update" method of removing cursors RE: Interesting problem for the "Running Total/Quirky Update" method of removing cursors

  • Although the max recursion is only a bit over 32K, any change in criteria will restart that recursion. You could easily run it on millions of rows... or it could crap out at 33k, it all depends on the data distribution.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]