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
