TABLE1:
ID value1
--- ------
1 123,456
2 777 TABLE2:
ID value2
--- ------
123 a
456 b
777 c 希望查询后得到:
ID value3
--- ------
1 a,b
2 c
CREATE FUNCTION dbo.f_str(@value varchar(10))
RETURNS varchar(100)
AS
BEGIN
DECLARE @re varchar(100)
SET @re=''
SELECT @re=@re+','+value2
FROM tb2
WHERE charindex(','+value2+',',','+@value+',')>0
RETURN(STUFF(@re,1,1,''))
END
GO
select a.id,f_str(value) value
from tb1
ID value1
--- ------
1 123,456
2 777 TABLE2:
ID value2
--- ------
123 a
456 b
777 c 希望查询后得到:
ID value3
--- ------
1 a,b
2 c
CREATE FUNCTION dbo.f_str(@value varchar(10))
RETURNS varchar(100)
AS
BEGIN
DECLARE @re varchar(100)
SET @re=''
SELECT @re=@re+','+value2
FROM tb2
WHERE charindex(','+value2+',',','+@value+',')>0
RETURN(STUFF(@re,1,1,''))
END
GO
select a.id,f_str(value) value
from tb1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货