TurnerC,

Someone will probably point out a much better way of doing this but getting a single column of multiple records into a comma-separated string can be done thusly:

SELECT STUFF((SELECT ',' + CAST(TableName.NumBeds AS varchar) FROM TableName FOR XML PATH('')),1, 2, '') AS CSVColumn

You have to CAST any output fields as strings (as long as they aren't already, I'm presuming your Number of Beds field would be an integer) for it to work.