SQL server query to combine multiple rows into single row

Question

Please help me with the sql query to retrieve a single row for each trip code which will combine all the rows of same trip code into one. For eg: in this example: ASSASSIN - 03 Sep 19 trip code had four columns.

Vinitha T · Answer

Check this,   My table:   Result with Query:   Here, STUFF command is used to combine the result together with separator comma (,).  FOR XML PATH command is used to get result as XML String to concatenate multiple column data into single row.

Kirtesh Shah · Answer

Please have a loook,   https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/   Hope it will help you.

Srinivasan Ramamoorthi · Answer

For few trip codes all the columns have same values but for other tripcodes the last 4 columns values are not same. If you try to do distinct or group by you will get 4 rows for trip code "ASSASSIN"