question

AypnCNN-4494 avatar image
0 Votes"
AypnCNN-4494 asked HafeezUddin-8965 answered

How to Merge rows in Sql

Hi Friends,

This is my Table,

 Create Table #Temp (DueDate1 int, DueDate2 int, DueDate3 int, DueDate4 int, DueDate5 int)
 Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,0,0,5)
 Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,0,4,0)
 Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,3,4,5)
    
 Select * From #Temp

Expected result is

102127-image.png


sql-server-generalwindows-server-2016
image.png (1.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

HafeezUddin-8965 avatar image
0 Votes"
HafeezUddin-8965 answered

You can try this.
Select max(DueDate1),max(DueDate2) ,max(DueDate3) ,max(DueDate4) ,max(DueDate5) From #Temp

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.