AnsweredAssumed Answered

Dynamic auto enterserial?

Question asked by Stu412 on Apr 1, 2015
Latest reply on Apr 1, 2015 by Stu412

Title

Dynamic auto enterserial?

Post

Hi, 

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?

 

Thanks

Outcomes