How to combine multiple rows into one row with different column in sql server

Question

I have table like this i want to get only one row for given budget id Here is the data.

INPUT:

OUTPUT:

You can group the data by BudgetId, but you need to decide how you want to summarize the other columns if you want to display the other columns. Because you're trying to display the "Initiator" for both 10002 rows in the same cell, how should the "Null" and "2" be handled? You need to summarize them with an aggregate function like MIN or AVG — EMUEVIL
– EMUEVIL, Commented Dec 27, 2017 at 16:01

Pரதீப் · Accepted Answer · 2017-12-27 15:56:06Z

1

Use Min/Max aggregate

SELECT MontlyBugetId,
       Min(Initiator),Min(Stage1),Min(Stage2),Min(Stage3),Min(Stage4),Min(StatusId)
FROM   yourtable
GROUP  BY MontlyBugetId

If this is your table data, then you need to update the records instead of insert to avoid duplicate records

answered Dec 27, 2017 at 15:56

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1