2008年7月15日 星期二

Delete Route

Delete the router record ( Sysm_id = 9 , 9 = 01/2008 , del after current month is better )

Find out the rsrf_id for TPMM's record ( TPMM Site_id = 85 )
select * from ros_site_roster_file where site_id = 85;

delete ros_site_roster_details where rsrf_id in (7461,7462,7463,7464);

delete ros_site_roster_file where rsrf_id = 7464;

commit;