chengben/Scripts/合同剔除后.sql

--¸üÐÂÌÞ³ý±êʶ
update sqmdb_cost.hetong_new set is_tc='ÊÇ' from sqmdb_cost.hetong_white 
where sqmdb_cost.hetong_new.sid=sqmdb_cost.hetong_white.hetong_sid 

--update sqmdb_cost.hetong_new set is_tc='·ñ'

--update sqmdb_cost.station_hetong set idx_date='20220805'

select 
sid,
sname,
bdate,
edate,
cost,
cname,
dname,
cfname,
cbzx,
ename,
signdate,
status,
stype,
taker_code,
taker_name,
taker_mobile,
nmonth,
yuezujin
from sqmdb_cost.hetong_new hn
where is_tc='·ñ'