Hello,
I am hoping someone might be able to help provide what should be a simple SQL query to update all instances of a certain e-market indicator (from TR_EMRKT_ID) to a different e-market indicator.
Thank you in advance!!
Dan Crowell
Hi Dan,
It's an easy thing to do - but as with any SQL update, ALWAYS test it in your TEST environment to ensure there are no undesired consequences.
update T_CUSTOMERset emarket_ind = 1 --whichever TR_EMRKT_IND.ID is the new valuewhere emarket_ind = 2 --whichever TR_EMRKT_IND.ID is the existing value
Martin
Hi Martin,
Thank you so much for your help! I knew it would be an easy one, I just don't trust myself enough to write it myself. I will be sure to run it in test first.
Much appreciated!!
Dan