data for only week days

• • Reply

  12 years ago

  by raju1923

  manglam kumar

  , India

  Joined 13 years ago

  Hi Friends,

  I need to write a query  in such away to extract the data from SQL server 2005 database for the LAST_MONTH Data and only WEEK days excluding the weekend days

  ORDERDATE

  03-01-2008

  .

  .

  03-31-2008

   

  There is all 31 days in the ORDERDATE but I need to exclude the WEEKENDS ...

  for the last Month.Please help ...!!!!!

   

  Thanks in Advance

  Claoker

   

  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  Try something like this:
   

  select OrderDate
  from Orders
  inner join
  (
      select
          datepart(yyyy, max(OrderDate)) as 'lastYear',
          datepart(mm, max(OrderDate)) as 'lastMonth'
      from Orders
  ) xxx
  on (datepart(yyyy, Orders.OrderDate) = xxx.lastYear)
  and (datepart(mm, Orders.OrderDate) = xxx.lastMonth)
  where (datepart(dw, OrderDate) between 2 and 6)

   

  Not perhaps as efficient as it could be but its a good enough starting point for you.

  Joe 

  Report abuse