Skip to Content
0
Former Member
Jul 12, 2012 at 12:19 AM

Autopopulate Code issu

15 Views

Experts,

I have the following FMS that auto populates the Code on a UDT with the next sequential number in the field @NRFSize,Code:

SELECT max(code)+1 from [@NRF_SIZE]

This populates correctly up untill number 10 then it repeats number 10. I see that this row that is created for line 10 jumps to the second row just after 1 and don't know if this is part of the issue.

Thanks,

Marli