mehrere Daten aus einer Spalte zusammenfügen - SQL Query

declare @ID int, @Info varchar (max)
declare @Ergebnis table (ID int, Info varchar (max))

declare c1 cursor for select distinct ID from Vertrieb order by ID
open c1
fetch next from c1 into @ID
while @@fetch_status = 0
begin
	select	@Info = ''  
	select	@Info = @Info + case when @Info = '' or IsNull (Info, '') = '' then '' else ', ' end + Info  
	from	Vertrieb
	where	ID = @ID
	order by Info

	insert into @Ergebnis (ID, Info) values (@ID, @Info)

	fetch next from c1 into @ID
end
close c1
deallocate c1

select * from @Ergebnis