All pastes #93764 Raw Edit

Unnamed

public text v1 · immutable
#93764 ·published 2006-07-20 18:59 UTC
rendered paste body
UPDATE trs_phx.prod_dial_def a, trs_phx.prod_dial_def b
SET a.dial_def_index=b.dial_def_index
WHERE a.switch_id=103 AND b.switch_id=101 AND
	 a.DIAL_SERVICES=b.DIAL_SERVICES AND
	 a.CARRIER_CODE=b.carrier_code AND
	 a.ORIGIN_TYPE=b.ORIGIN_TYPE AND
	 a.prod_id=b.prod_id AND
	 a.DIAL_DEF_INDEX!=b.DIAL_DEF_INDEX