SQL 同步更新 记录20230523

?

--清除临时表1

drop table #temp

--取得休位次数

select * into #temp from (select

fbarprjcode,fmolotno,fbarfgsize,fbarfgsize2,fsmalltypename,len(fbarfgsize2)-len(replace(fbarfgsize2, '休位', ' ')) as Times from [dbo].[tstkbarprjhdr] where ffgplaneddate>'2023-04-01') as A

--查询休位出现两次

select * from #temp where Times=2

 

--清除临时表2

drop table #temp2

select * into #temp2 from(select * from #temp where Times=2) as B

--修改休位

update #temp2 set fbarfgsize= replace(fbarfgsize, '+休位','+休位+休位')

--同步更新，注意链表为更新表

--update B SET B.fbarfgsize2=A.fbarfgsize2 FROM #temp2 A INNER JOIN [dbo].[tstkbarprjhdr] B ON A.fbarprjcode=B.fbarprjcode

select * FROM #temp2 A INNER JOIN [dbo].[tstkbarprjhdr] B ON A.fbarprjcode=B.fbarprjcode