set nocount on
--==========================================
--DDL/DML

--table
create table myTable
	(regionid int
	,typeid int)
go

--table data
insert myTable
select 1,1 union all
select 1,2 union all
select 1,3 union all
select 2,1 union all
select 2,2
go

--function to build comma seperated string of typeids
create function dbo.fnBuildCSVTypeIDs (@regionid int)
returns varchar(50)
as
begin
	declare @str varchar(50)
	select @str = coalesce(@str + ', ' + convert(varchar,typeid), convert(varchar,typeid))
	from	myTable
	where	regionid = @regionid
	order by typeid
	
	return @str
end
go

--==========================================
--select statement using the function
select	regionid
	,typeIDs = dbo.fnBuildCSVTypeIDs(regionid)
from	myTable
group by regionid

--==========================================
--cleanup
go
drop function dbo.fnBuildCSVTypeIDs
drop table myTable
go