• It's ok. Everybody forgets the index :-P.

    I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR functions can beat it in some instances(per Adam Machanic), but the next fastest method for something like this that I know of is just a straight up loop/cursor.

    If anyone reading this knows of a high performance method other than CLR/Quirky Update/Cursor/Loop to do iterative logic like this, I'd love to hear about it.

    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]