to find specific day between two periods

• dhamodharankms

  SSC Enthusiast

  Points: 145

  More actions

  January 3, 2011 at 9:51 pm

  #229243

  Hi

  Good morning,

  I want to calculate how many thursday occures between 2011-01-04 to 2011-01-20.

  Is there any specific functions in SQL 2008? else tell me how can we find?

  Thanks in advance

  Regards,

  Dhamu

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 3, 2011 at 10:10 pm

  #1268739

  Hi..

  Pls try this link

  http://weblogs.sqlteam.com/peterl/archive/2009/07/12/How-to-calculate-the-number-of-weekdays-for-any-given.aspx

  Also

  http://www.sqlservercentral.com/Forums/FindPost961135.aspx

  Please reply , if these links helped you.

• dhamodharankms

  SSC Enthusiast

  Points: 145

  More actions

  January 3, 2011 at 10:27 pm

  #1268743

  consider my start date is 01/01/2011 and my end date is 20/01/2011. I want to calculate how tuesday occured between those period

• sivaj2k

  Ten Centuries

  Points: 1188

  More actions

  January 3, 2011 at 11:55 pm

  #1268755

  Try this

  declare @t table (id int identity(1,1),time_stamp date)

  declare @st date,@en date

  select @st = '2011-01-01'

  select @en = '2011-01-20'

  insert into @t

  select convert(varchar(10),@st,110) from INFORMATION_SCHEMA.COLUMNS

  update @t set time_stamp = dateadd(day,id-4,time_stamp)

  select time_stamp from @t where time_stamp between @st and @en

  and datename(weekday,time_stamp) = 'Tuesday'

  Regards

  Siva Kumar J