TOP

RegSource Sync Stuff

Read More
TOP

Me Sql query example — SAVE

use DB_2271_main;

insert into nf_alert_region_entity ( alert_region_id, alert_entity_id, region_id, ncr_number )
select  b.alert_region_id, a.entity_id as alert_entity_id , a.region_id, c.ncr_number
from regions_entities a, nf_alert_region b, entities c 
where b.region_id=a.region_id and c.entity_id=a.entity_id


update nf_alert_region_entity set entity_name=
(select nf_alert_entity.entity_name from nf_alert_entity where nf_alert_entity.alert_entity_id=nf_alert_region_entity.alert_entity_id)

Read More
TOP

Protected: VPN

This content is password protected. To view it please enter your password below:

Read More

Switch to our mobile site