Consolidate Rows on Select

From: Dan (anonymous_at_discussions.microsoft.com)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 12:49:37 -0700

I want to condense several rows of a table using a select
statement, function, or stored procedure

For Example
mytable :
1 a
2 b
2 c
2 d
3 a

so that my select should result in

1 a
2 b,c,d
3 a

Any ideas or suggestions?