The table contains job data. Each code can have multiple extensions. I need to figure out how to loop through this data, and add an auto increment count for each unique job code and extension and then reset, continue on and continue counting. So for example here is the new format I need of the above data:
Basically I need a bullet number count for each entry of a unique job code and extension. So since 1199-0 had 3 entries, it auto counts those 3. Then it sees that unique job code and ext is done, sees 1199-1 and starts the count of bullet items etc.
Need help with SQL update/loop
Posted - 06/21/2010 : 10:29:26
