I'm glad it worked for you.

The reason people are asking you questions about your data and referring you to data types is that we don't know your data.  The data type determines precision and range...

I've seen Wayne's presentation on table variables versus temp tables.  It's a good one.  Now I'll have to read the article. 😉  Thanks, Gail.

A stored procedure would go a long way toward solving the problem.  One benefit is that you'll know the parameters will be received with the proper data types and you'll...

Whatever approach you end up using, make sure you have all possible times covered the way you want them covered.
If, for example, you're getting your string from a datetime...

Database mail isn't a mail server - that's Exchange.  Database mail needs a mail server because it can't send email.  It builds up what it needs and sends it off...

In addition to what Sue suggested, also look for logins with the securityadmin role.  If you have 6 logins with sysadmin, make sure they're all AD logins so you know...

First of all, welcome to SSC.

With the function, why are you passing the datetime parameter as a string?  If you can, pass it as a datetime instead.

If you want to...