number weeks from April to September for every year

  • Thread starter Thread starter kvd123
  • Start date Start date
K

kvd123

Guest
I want to number weeks from April to September for every year, such that week 1 starts 1st of April and ends the following Saturday and week 2 starts first Sunday of April and ends the following Saturday and so on.... till the end of September. How do I do that using TSQL.


Thanks in advance.

Continue reading...
 
Back
Top