SQL query to update Emarket Indicators

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_CUSTOMER
set emarket_ind = 1 --whichever TR_EMRKT_IND.ID is the new value
where emarket_ind = 2 --whichever TR_EMRKT_IND.ID is the existing value

Martin

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_CUSTOMER
set emarket_ind = 1 --whichever TR_EMRKT_IND.ID is the new value
where 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