[RESOLVED] Concatonating data in SQL server 2005

[wild_bill]

Given the following table, how could I create a query to return:

-------
|a|1,2|
-------

declare @table table(id char(1), sub_group int)
insert into @table (id, sub_group) values ('a',1)
insert into @table (id, sub_group) values ('a',2)