This is an application for Jonathan's daterange function.  Here is his article:

https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

Something like this:

declare
   @input_yearint=2019,
   @input_monthint=9;
declare
  @test_monthdate=datefromparts(@input_year,@input_month,1);

 select
 ...

damn, that scuppers that idea then.

as i have a problem that this might have been a solution for.

is this compatible with SQL2000?

the only days i would be exluding are weekend days (so no other holidays to be excluded).

so would a calendar still be the most appropriate way to do this?

I currently...

• This reply was modified 5 years, 2 months ago by  chenks.