Loop insert

boing · #1 (**permalink**) 07-18-06, 06:08

Hi,

I will do my best to explain my question:

I have a field called CUSTOMER which contains a number such as C00001,
C0002 etc.

However i now have a new field called XCUSTOMER which is the new number that they relate to.

CUSTOMER C00001 now relates to XCUSTOMER 493845.
CUSTOMER C00002 now relates to XCUSTOMER 494343.

Basically there are hundreds of these and i dont have the time to manually enter the data. I just want to say "where customer = C00001 then insert 49494 into XCUSTOMER and then loop through and insert them all.

My table is called CUSTOMERINFO.

If anyone could help it would be much apprieciated as it would save me so much time.

Thanks

r937 · #2 (**permalink**) 07-18-06, 07:32

Code:

update customerinfo
   set xcustomer = case customer
                            when 'c00001' then 493845
                            when 'c00001' then 494343
                            ...
                         end

Internet Services

Web Development

Digital Marketing

Consumer Tech