sql server 2000 - Generate list of week number + start date + end date against any year using SQL query -


i want generate temp table following columns:

  • weekno
  • startdate
  • enddate

using udf having year parameter (year(yyyy)).

why should consider using auxiliary calendar table?


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -