Guest User

Untitled

a guest
Feb 17th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. * Starting Month Starting Day
  2. 02 17
  3.  
  4. ,min(a.[Month]) as StartingMonth
  5. ,min(case
  6. when min(a.[Month]) = 01 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  7. when min(a.[Month]) = 02 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  8. when min(a.[Month]) = 03 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  9. when min(a.[Month]) = 04 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  10. when min(a.[Month]) = 05 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  11. when min(a.[Month]) = 06 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  12. when min(a.[Month]) = 07 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  13. when min(a.[Month]) = 08 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  14. when min(a.[Month]) = 09 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  15. when min(a.[Month]) = 10 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  16. when min(a.[Month]) = 11 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  17. when min(a.[Month]) = 12 then (select min(a.[Day]) from table1 where a.[Month] = 01)
  18. else null
  19. end) as StartingDay
Add Comment
Please, Sign In to add comment