Last 5 business days query

[jdgonzalez]

Hi everyone,

I'm hoping someone can help me out here. I have got a table that holds call tracking information. The table looks like this:

note_id, note_desc, call_date, entry_date

What I'd like to do is to be able to pull the notes for the last 5 business days from today.

Any help would be greatly appreciated.

J.D.

 

[checkai]

this displays the last 5 work days (mon-fri)

declare @date1 datetime
set @date1 = getdate() - 7
declare @days table(
  [date] smalldatetime,
  day_number tinyint)
  while @date1 <= getdate()
    begin
      insert into @days ([date],day_number) values (@date1, datepart(dw,@date1))
      select @date1 = dateadd(d,1,@date1)
    end

select * from @days
where day_number in (2,3,4,5,6)

should be a good start...

"...we both know I'm training to become a cagefigher...see what happens if you try 'n hit me..."