Bys update statement
-- insert the required data
Insert INTO xtsw_ym.dbo.splsk
Select plh, dj_sn, spid, rq, dwbh, yishj, yjzh, djbh, bm, ywy,', zhy, jzhh, hw, pihao, rkshl, rkdj, rkje, chkshl, chkje, xshe, xshje, ml, jcshl, jcje, chbdj, lshj, hwjcsh, hwjcer, plcj,', bendian,', '0.00'
From openrowset ('SQLOLEDB',' 192.168.16.237; 'SA';' zdyysm,.',ymksoa.dbo.splsk)
Where (djbh like 'jha%' or djbh like' jhc%' or djbh like 'xsa%' or djbh like' xsc%')
And spid in (select spid From spkfk where shengccj like'% Guangzhou Baiyunshan Hutchison Whampoa traditional Chinese Medicine Co., Ltd.%') and rq > = '2018-12-26' and rq
