I am writing business dateadd functions, so if you need 5 business days you would ignore weekends and holidays based on the appropriate holiday calendar. We look at bank holidays and...

Yes, Ed, nicely done. I didn't realize that you could grab the return value like that. I'm writing some business date functions and would like to be able to pass...

Thanks for your help anyway.

Normally one would set a varchar variable with single quotes.

I just realized that the dynamic sql won't work because I need to set a variable to the date returned by...

Thanks. That was fast! I was hoping to avoid dynamic sql, but seeing how short it is I see that it's probably a better solution than a lot of if...