I just became aware of the fact that SQL Server Central subscribers were still accessing this version of Calculate Holidays. This was written years ago and I have since...

Thank you Chris M. Will be giving this a try later today. Will keep you posted on how I do. Thanks again.

Additional information: I only want to updated the most recent existing record and not all of the existing records pertaining to the target memberID. Otherwise, I am updating...

A great and most helpful article. Keep up the good work.

Solved it as follows:

EXEC sp_executesql @SQL

This will execute the user defined function.

Thanks for your input DavidT.

Okay. So, now, I have created a separate scalar function returning a varchar(300) and in the calling procedure created a dynamic sql statement that is supposed to execute the...

I would like to reply to each of you as you gave me a number of things to think about but instead, I will make some general comments.

I agree that...