If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Stored Procedure to generate a comma seperated list

I frequently run into a situation where I need to find all entries in a table for a particular key value and then build a simple list of the values seperated by commas.
Usually I display this list either in a Textbox on a form or in a report.

Simple Example: List all Fruit in the Products Table

In my VB code I create a recordset for all Products where the Type is Fruit and then loop through the records and build my string, which in this case would look something like this:
Apple, Orange, Peach, Pare, Strawberry, Mango

Is there a way to turn this VB code into a stored procedure in SQL Server?

I seem to be building lists like this a lot so a stored procedure, to get the processing of of the client onto the server, would be very handy.