SQLScholar
Programmer
Hey all,
I have an insert from excel spreadsheet that needs to take our Ref number, for a client - and find the next transaction number it is suppose to have (last number off the last record for the ref number +1).
To do this with DTS, i have an idea how to do (create a dummy table, on the insert into the live find the counter). What i dont know is when i do the insert from the dummy to the live what happens if the same excel sheet (and therefore dummy table) had 2 ref numbers the same (2 transactions for the same client).
Then how would i find that the first transaction needed for instance 4, and the second would need 5.
I hope this makes sense.
Dan
----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
I have an insert from excel spreadsheet that needs to take our Ref number, for a client - and find the next transaction number it is suppose to have (last number off the last record for the ref number +1).
To do this with DTS, i have an idea how to do (create a dummy table, on the insert into the live find the counter). What i dont know is when i do the insert from the dummy to the live what happens if the same excel sheet (and therefore dummy table) had 2 ref numbers the same (2 transactions for the same client).
Then how would i find that the first transaction needed for instance 4, and the second would need 5.
I hope this makes sense.
Dan
----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------