Even if they are fixed values, do not use literal dates in your WHERE clause - performance will suffer badly. Declare DateTime variables and use those, eg :

DECLARE @Date1...

Be careful with table variables though - with many rows they are held on disc anyway so no i/o gain and they cannot be handled by parallel execution plans on...

For performance, create a calculated column with just the date part and index that.

Brilliant !!!

Its 6.5

Not 'my' database so I didnt think to check.

Many thanks for your help.

Gives the same error.

I just tried it on a different server though and it worked fine!

Both are Windows Authentication and Ive ensured that Ive got every permission in sight on...

Just in case of a simple typo, I edited the posted code to :

SELECT FundNo FROM dbo.EstDealDetail

That runs fine.

Thanks for the response.

Yes. Copied directly from QA. Neither I nor a couple of colleagues could see anything wrong, hence the posting.

It's a question of balancing risk. What's the probability of the vulnerability being exploited and what damage might that do against the probability of the patch causing an issue...

Why shoulkd you want to remove the time?

Typically because you have been passed a datetime but want to select data for a range of complete days.

This comes up regularly. Ive tested most scenarios in the past and datediff/dateadd always comes out the fastest - often by a good margin. It also has the...

I would just emphasise : if there is ANY possibility of confusion for you or a successor, ALWAYS use parentheses. You cannot overclarify or overcomment code. Always think...

I would recommend always to use OUTER for clarity. As a general rule, never abbreviate commands even when the parser allows it. You never know who will have...

Remember that ASCII zero is C's (LPSTR) string terminator character. Sounds as if something is failing to read past it.

There cannot be a general answer. What are you going to use it for?

If it is to be deployed as part of an embedded device than there are specialist...

if Field_1 etc are indexed, you will be filtering the result set so that the udf is called for less rows (look at the query plans). The use of...