First Work Day of the month ?

use AdventureWorks2008;

go

create function fnFirstWorkDayOfMonth( @Year int, @Month int)

returns datetime

as

begin

              declare @FirstDayOfMonth datetime

set @FirstDayOfMonth = convert(datetime, convert(varchar,@Year)+'-'+convert(varchar,@month)+'-01')

              if datepart(weekday,@FirstDayOfMonth) not in (1,7)

      return (@FirstDayOfMonth)

set @FirstDayOfMonth = dateadd(day,1,@FirstDayOfMonth)

if datepart(weekday,@FirstDayOfMonth) not in (1,7)

      return (@FirstDayOfMonth)

      return (dateadd(day,1,@FirstDayOfMonth))

              end

go 

select dbo.fnFirstWorkDayofMonth (

      year(getdate()),

      month(getdate())

      )

go