Seems this solution is a sign of missing governance or process in the organization, and can slow down the people affected, including the DBA the developer and everybody else. Instead...

i posted that solution years ago, you just copied it and messed it up, please delete it

Sounds like you have a datetime as a part of a unique constraint or pk.

This did not do it for me:

select dbo.GetNextBusinessDay(getdate(),1)

select dbo.GetNextBusinessDay(getdate()+1,1) -- Fri

select dbo.GetNextBusinessDay(getdate()+2,1) -- Sat

select dbo.GetNextBusinessDay(getdate()+3,1) -- Sun

------------------------------------------------------

2007-04-27 12:41:00

(1 row(s) affected)

------------------------------------------------------

2007-04-30 12:41:00

(1 row(s) affected)

------------------------------------------------------

2007-04-29 12:41:00

(1...