Heh, so now I've gone from having no way of working sequence numbers to having more methods than I know what to do with

Yeah, that should do the trick; repeat the same process for each groupID in the set.

I guess I was looking for a single "magic update" that did the whole thing...

leokarp said:

"There is very simple and fast way without using any temporary table or subquery. Steps to implement it:

1. Alter table to add an additional column for sequence numbers.

2....

Ian Scarlett Said:

"This may not be particularly efficient, especially if the table is large, but try this:- select (select count(*) from names n2 where n2.name <= n1.name) as SeqNo,name...

When I had to add a data exporting tool to a program I'm working on, a co-worker suggested I use DTS. To make a long story short, I looked into...