Howdy! I ran across this TSQL snippet that renders a column as a comma delimited list (see this):
DECLARE @TeamInfo varchar(max)
SELECT @TeamInfo = COALESCE(@TeamInfo + ', ', '') + FirstName
FROM TeamInfo
WHERE TeamID = @TeamID
I've run across jQuery components that prefer these lists, and this is a great way to build them.
Steve
