The double quote at the end of the SQL query ism't matched by a double quote at the beginning of the query. It isn't needed, anyway.

(Edit:) Sorry. Small screen.

• This reply was modified 4 years, 1 month ago by  PhilPacha.

Look at ROUND(), particularly the last parameter.

You might check to see if 'auto-close' is specified for the database.

Thanks for the update about datetime --> date; I wasn't aware of that.

A CAST on the database column would likely preclude the use of an available index, while using the native values would allow index usage, if available. The >= and <...

Since you are referencing two databases, you have to specify the database name for the object (function or table) which is in the database you are NOT running against. In...

I have tried multiple times, both yesterday and today. I can't get through...

The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as...

What about [YourNumerator] / NULLIF([YourDivisor], 0) ? If the divisor is zero, it become null, and the result is null. Then handle the null quotient in the method best suited...

Sorry, everyone! I've removed the typo from my earlier post. Stupid fingers!

Trying to add an arbitrary amount of 'time' to a datetime value which starts out containing ONLY a date is fraught with problems. Try adding the last millisecond or two,...

There is a way to make an un-trusted constraint (Check or Foreign Key) trusted.

From BOL:

"The query optimizer does not consider constraints that are defined WITH NOCHECK. Such constraints are ignored...

IDENTITY_INSERT can only be 'ON' for a single table at a time, and there is no easy visibility to which table currently has this option turned 'ON'. Therefore, it's important...

The first thing I noticed was that there is no path or drive letter specified for the source or results file. Offhand, I don't know the default path for a...

SQL Server Agent recognizes a variety of 'tokens', which it will replace at runtime with the appropriate value. 'JOBID' is one of those tokens.

In some cases, you must add...

In many jurisdictions, what they did could be considered fraud, and make them liable for civil or criminal liabilities.