>Trying to avoid cursors and procedural code in tsql
>
>I have a table derived from an SSIS feed that has 1 - n rows that are related, based on symbol, eff_date. If there are more than 1, I want to concatenate the values in a varchar column into the first row
>
>1000 rows, may have 200 rows belonging to 60 sets of 2-4 members
>
>First row of set and any row that has no set has a Seq_num = 1 ( also have a column fgkey int which acts as a key for a set so can use that instead of symbol, eff_date to find rows belong to a set. Singleton rows have no fgkey )
>
>I also have a bit column which I want to be 1 in the first row if any of the rows in the set have a 1
>
>So
>symbol eff_date terms price_sens seq_num
>MSFT 20120601 'string1' 0 1
>MSFT 20120601 'string2' 1 2
>MSFT 20120601 'string3' 0 3
>
>would become
>
>MSFT 20120601 'string1 , string2 , string3' 1
>MSFT 20120601 'string2' 1 -- ( this can stay as it is)
>MSFT 20120601 'string3' 0 -- ( this can stay as it is)
>
>Basically it would be an aggregate function but on strings instead of adding numbers.
>
>If a sum of a bit column would work for finding if the total > 0 I can work that part out.
>
>Looking for some set-based command or magic that would concat the strings
>
>TIA

Read these blogs

MSDN thread about concatenating rows

Making a list and checking it twice
Concatenating Rows - Part 1
Concatenating Rows - Part 2