create table tb(col1 varchar(10),col2 varchar(10),col3 varchar(10),col4 varchar(10))
go
insert tb select '11111' , '222' , 'A' , 1
insert tb select '1111' , '333' , 'A' , 1
insert tb select '2222' , '999' , 'B' , 2
insert tb select '3333' , '111' , 'B' , 2
go
create FUNCTION dbo.f_str(@col3 varchar(10))
RETURNS varchar(8000)
AS
BEGIN
declare @str varchar(8000)
set @str=''
select @str=@str+case when charindex(','+col1+'-',','+@str+'-')=0 then col1+'-' else '' end
+case when charindex('-'+col2+',','-'+@str+',')=0 then col2+',' else '' end
多行合并2列并去掉重复列。
最新推荐文章于 2021-08-25 11:11:39 发布