Displaying data from multi row to single row 1

egodette · Aug 20, 2012

I have a table with 3 fields. These fields contain duplicate entries for two of the fields. This SQL statement produces these results.
SELECT * FROM MULTCLAS WHERE TICKER = 'TLP'
TLP XZ PRT
TLP XZ SHL

What I want is an sql query that procudes:
TPL XZ PRT SHL

Any help would be appreciated..

imex · Aug 20, 2012

Try something like that:

Code:

SELECT TICKER, COLUMN2, STUFF( (SELECT ' ' + COLUMN3
                                FROM MULTCLAS
                                WHERE (TICKER = M.TICKER) AND (COLUMN2 = M.COLUMN2)
                                FOR XML PATH(''), TYPE).value('.', 'varchar(max)')
                                ,1, 1, '')
                                 
FROM MULTCLAS AS M
GROUP BY TICKER, COLUMN2

Hope this helps.

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Displaying data from multi row to single row 1

egodette

Technical User

imex

Programmer

Similar threads

Part and Inventory Search

Sponsor