Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- * Starting Month Starting Day
- 02 17
- ,min(a.[Month]) as StartingMonth
- ,min(case
- when min(a.[Month]) = 01 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 02 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 03 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 04 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 05 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 06 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 07 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 08 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 09 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 10 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 11 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- when min(a.[Month]) = 12 then (select min(a.[Day]) from table1 where a.[Month] = 01)
- else null
- end) as StartingDay
Add Comment
Please, Sign In to add comment