update netmonitor_obj h set ( monitorstatus ) =(select monitorstatus from table1 where taskid = '6453f1ac-f1de-45ea-8173-95a2c11b61a0' and historyobjid = h.objid)
where objid in (select historyobjid from table2 where taskid = 0000)
string sqlinsert = @"insert into net_obj(objid,salesdepartmentid,officeid,countryid,provinceid,prodclassid,network,netdelegateid,interfaceid,netgrade,operator,created_by,creation_date,last_updated_by,issendmail,isactivety,sendmail_count,sendmail_time,monitorstatus,historyname,maintainid,projectid)
select objid,salesdepartmentid,officeid,countryid,provinceid,prodclassid,network,netdelegateid,interfaceid,netgrade,operator,created_by,creation_date,last_updated_by,issendmail,isactivety,sendmail_count,sendmail_time,monitorstatus,network2,maintainid,projectid from TB where taskid='{0}'";
string sqlUpdate = @"update netmonitor_obj h
set (salesdepartmentid,
countryid,
provinceid,
prodclassid,
network,
netdelegateid,
interfaceid,
netgrade,
operator,
created_by,
creation_date,
last_updated_by,
issendmail,
isactivety,
sendmail_count,
sendmail_time,
monitorstatus,
historyname,
maintainid,
projectid) =
(select salesdepartmentid,
countryid,
provinceid,
prodclassid,
network,
netdelegateid,
interfaceid,
netgrade,
operator,
created_by,
creation_date,
last_updated_by,
issendmail,
isactivety,
sendmail_count,
sendmail_time,
monitorstatus,
historyname,
maintainid,
projectid
from TASK where taskid = '{0}'
and historyobjid = h.objid)
where objid in
(select historyobjid
from table3 where taskid = '{0}')";