如圖所示
分組好的資料 兩條為一個分組 將Years欄位進行比較 他們是包含和被包含關系 被包含的Issn值需要修改成No
在線求大佬解答 感謝！！！
uj5u.com熱心網友回復：
if OBJECT_ID('tempdb..#Table_1')is not null drop table #Table_1
create table #Table_1(Title nvarchar(2),Issn nvarchar(max),Years nvarchar(max))
insert into #Table_1(Title,Issn,Years)(
select 'aa' Title,'1231-1233'Issn,'2013,2014'Years union all
select 'aa' Title,'1231-1233'Issn,'2013,2014,2015,2016'Years union all
select 'bb' Title,'1231-1233'Issn,'2013,2014,2017,2018'Years union all
select 'bb' Title,'1231-1233'Issn,'2017,2018'Years
)
update #Table_1 set Issn='No' from #Table_1 a where
exists(select 1 from #Table_1 b where a.Title=b.Title and a.Years<>b.Years and
CHARINDEX(a.Years,b.Years)>0 )
/*結果
aa No 2013,2014
aa 1231-1233 2013,2014,2015,2016
bb 1231-1233 2013,2014,2017,2018
bb No 2017,2018
*/
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/32794.html
標籤：疑難問題
上一篇：資料庫系統概論
下一篇：求教大家