Paul White (9/7/2009)
It's good to hear you are keeping busy anyway 🙂Though the management side of things sounds quite dull.
The management side of things is dull! I would like to get rid of it - really - ...
I think you're referring to windowing functions like ROW_NUMBER...is that right? I'd like to be sure I understand you correctly.
That sure can be an efficient way to add a sequence number 'on the fly' - but I stand by my claim that the script I posted remains the fastest way to add persistent sequential numbering to a large table (Jeff's caveats noted).
Yep, that's what I mean.
I'm sure that your way to create a sequential numbering is the fastest way. I already added your post to my snippets ;-). The only thing is, it requires the (temporary) table not to exist.
Hope you are well.
Yes, I'm well. Weather is really nice and Oktoberfest starts in less than two weeks. (And there will be thousands of guys from New Zealand here in Munich :-P)
What about you? Things are fine?