Do I need to create a temp table?

• Rob Sawnic

  SSC Eights!

  Points: 940

  More actions

  March 12, 2004 at 8:02 am

  #152071

  I want to find out the number of Fridays between a certain date range. Do I need to create a table that I could select from first?

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 12, 2004 at 8:52 am

  #498531

  NO you don't but it may be easier to maintain

  In any case if you don't want to create the table just use:

  declare

    @start datetime

  , @end   datetime

  select

    @start = '20040306'

  , @end   = '20040326'

  select  datediff (wk, @start, @end)-1

   + case  when datepart (dw, @end)   >= 6 then 1 else 0 end

   + case  when datepart (dw, @start) <= 6 then 1 else 0 end  as NoFridays

  

  
  * Noel