Select multiple rows into one row.

[DDR]

Hi all, I have a table like the following


Name col1 col2 col3
------------------------------
Name1 A B C
Name1 D E F


And I want a query to select multiple rows with the same name and put them in one row like this


Name col1|1 col2|1 col3|1 col1|2 col2|2 col3|2
-------------------------------------------------------------------
Name1 A B C D E F


is that possible???

 

[mimi2]

do a search by "from rows to columns" in this forum.

 

[tlbroadbent]

Or search for Crosstab. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm