Rollup to one record with same order number

[ciarra41]

I have multiple rows with duplicate orders numbers and separate order types where as some are null and some are not. How can I roll these up into one record by order number and where there’s null it will pick the corresponding value that is not null for the same order number? It can be two are more instances like this.

 

[ciarra41]

here's the example;

employeecode Monday Tuesday Wednesday Thursday Friday Saturday Sunday
502025 Rostered NULL NULL NULL NULL NULL NULL
502025 NULL Rostered NULL NULL NULL NULL NULL
502025 NULL NULL Rostered NULL NULL NULL NULL
502025 NULL NULL NULL Rostered NULL NULL NULL
502025 NULL NULL NULL NULL Rostered NULL NULL


I would like it just have one row and it just looks like this:

employeecode Monday Tuesday Wednesday Thursday Friday Saturday Sunday
502025 Rostered Rostered Rostered Rostered Rostered NULL NULL

 

[drlex]

Would a grouping and a MAX be sufficient?

select [employeecode], Max([Monday]), Max([Tuesday]),Max([Wednesday]), Max([Thursday]), Max([Friday]), Max([Saturday]), Max([Sunday]) from <your_table> group by employeecode

(FYI: not really a DTS question, more a programming one - forum183)

soi là, soi carré