Combining Rows in a table 1

[jconway]

Hello all,

I have a notes table that records every note for an account as a separate entry. I want to create a view that has all the notes in 1 field to make it easier for reporting. So I have:

Note ID Acct # Note NoteDate
1 555 Activated Account 7/23/2012
2 555 Called Insurer 7/30/2012
3 600 Activated Acct 7/25/2012


What I want is a table that will show:
Acct# Notes
555 Activated Account, Called Insurer

Thanks in advance for any help

 

[imex]

Hi,

Try something like that:

SELECT Acct#, STUFF( (SELECT ', ' + Note
                      FROM MyTable
                      WHERE Acct# = t.Acct#
                      FOR XML PATH(''), TYPE).value('.', 'varchar(max)')
                      ,1, 2, '') as Notes
FROM MyTable as t

Hope this helps.


[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]