D
doug
I would like to write a query that inserts data into a table based on
parameter data. The number of records inserted would be a parameter, but i
also want to create a unique serial number for each record, incrementing by
1, starting with one of the parameter values.
For example:
Parameter item number - enter 123
Parameter Qty - enter 20
Parameter Starting Serial # - enter 1000
I then went 20 individual records inserted into the table. All with item
number 123 and serial numbers 1000-1019.
What is the best and most efficient way to accomplish this?
Thanks in advance.
parameter data. The number of records inserted would be a parameter, but i
also want to create a unique serial number for each record, incrementing by
1, starting with one of the parameter values.
For example:
Parameter item number - enter 123
Parameter Qty - enter 20
Parameter Starting Serial # - enter 1000
I then went 20 individual records inserted into the table. All with item
number 123 and serial numbers 1000-1019.
What is the best and most efficient way to accomplish this?
Thanks in advance.