SQL Server : I need to combine multiple rows into one row with different column values

Question

I have a view

Order          Drink       Entree         Desert  
--------------------------------------------------
12             Null        Preparing      Null  
12             Ready       NULL           NULL   
12             NULL        NULL           Waiting

I want to convert it to:

Order          Drink       Entree         Desert  
---------------------------------------------------
12             Ready       Preparing      Waiting

I know this isn't the question you asked, but why on Earth do you have only one column with a non-NULL value on each row? Something is very wrong with the design that created this mess. Change the INSERTing code as soon as possible. — jpmc26
– jpmc26, Commented Apr 25, 2017 at 0:48

Lamak · Accepted Answer · 2017-04-24 20:25:04Z

5

You can use an appropriate aggregation function. In this case, it seems like MIN or MAX will do the trick:

SELECT Order,
       MIN(Drink) Drink,
       MIN(Entree) Entree,
       MIN(Desert) Desert
FROM dbo.YourTable
GROUP BY Order;

answered Apr 24, 2017 at 20:25

Lamak

2,5761 gold badge24 silver badges30 bronze badges

1

That's what I would have done as well. If, of course, you might have more than one non-null row for the same order, then you'd have to figure out how to reconcile that.

BradC
– BradC

2017-04-24 20:27:57 +00:00
Commented Apr 24, 2017 at 20:27
@BradC exactly, but there's no enough information in the sample data

Lamak
– Lamak

2017-04-24 20:30:09 +00:00
Commented Apr 24, 2017 at 20:30

Add a comment |

Stack Exchange Network

SQL Server : I need to combine multiple rows into one row with different column values

1 Answer 1

Your Answer

Linked

Hot Network Questions

SQL Server : I need to combine multiple rows into one row with different column values

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions