Dynamic auto enterserial?
Not sure how to approach this. I have a task which generates a whole bunch of new records on a given table. By design, each time I run the task, it deletes existing records and replaces them with new, updated records.
I'm using the auto enter serial number in a resulting view.
Each time I run the task, I want this auto enter number reset to 1. There's no risk associated here as this field will never relate to anything else.
Is there a way that I can tell the table involved to always reset to 1 when the script for my routine is run?