I have a "default" set of values in table XZY
Field A = 'DEFAULT'
Field B = 'Other
Field C....E .. whatever
the Primary key is A & B
There are 10 or more records with FIELD A as 'DEFAULT"
In a stored proceedure, I want to create a new of records
from 'DEFAULT' and change that to 'NEWVAL' as example
In basic script it would look something like this:
Rs.Open Select * From XYZ Where FieldA = 'DEFAULT'
RX.add RX.FieldA='NEWVAL' RX... all other fields the same Rx.Update
So How would I do this in Stored Procedure, or Can I ?
Was thinking some temp table, but I get lost on the Add or the insert