User-1786411686 posted
Cursor is not required. Here's a sample: This method could be a little bit slower if you are using this function on too many rows ( > few thousands of rows) because the function has to be evaluated for each row.
create table table2 ( refID int , Name varchar(10))
insert into table2 select 12, 'qq' union all
select 12, 'cc' union all
select 12, 'dd' union all
select 10, 'rr'
alter function dbo.fn_GetOtherWords( @id int)
returns varchar(100)
as
begin
declare @otherwords varchar(100)
select @otherwords = isnull(@otherwords,'') + ',' + name from table2 where refid = @id
return right(@otherwords, len(@Otherwords) - 1)
end
go
declare @table1 table (Name varchar(10), id int)
insert into @table1 select 'a', 12 union all
select 'b', 10
select name, id, dbo.fn_GetOtherWords(id)
from @table1
