SELECT C.category, C.enquiryDescription, C.resolution, C.startDateTime, C.endDateTime, C.totalDateDiff, C.dateOnlyStart, C.dateOnlyEnd, C.MF_SR_ID

FROM myForms.myUser.CallLogRevenuesBACKUP20050802 C

WHERE (C.MF_SR_CTS Between ? And DATEADD(ms, 86397, ?))

This adds all but 3 milliseconds to the day (minimum time resolution...

See my previous post. You are dealing with a DateTIME. By entering a pure date, you are saying that the time is midnight (at the start of the...

A DateTime column holds just that (as a floating point numeric). It can be displayed in various ways but it is not held like that. You can't do...

Phil's original response should do what you want, then. Just modify the input string into the required string format (ie with /s) and perform a simple search. You...

Sorry, I've no experience of Microsift Query. I'm not sure why you are referring to wildcards. DateTimes cannot have them but you can do a wildcard search with...

Moving the tables will have physically defragmented them. Is there a clustered index? Have you tried a reindex? It looks like some kind of i/o contention.

For resilience, I would suggest that you use CONVERT() rather than CAST(). CONVERT() allows you to specify the date format, otherwise you are reliant on the database setting or...

The administrator can be based on her/himself or have a special value, eg zero or negative. It need not be null.

Thinking about it, everyone has a reference set for...

For each attribute, you either can make it nullable (if null then inherit) or have a parallel field to serve the same purpose. The nested sets tree model to...

If you prefix with n (Unicode), you are using two-byte characters, so you are limited to field widths of 4030 characters instead of 8060 (assuming a single field table!) and...

I picked up this very interesting reference on this site back in April :

http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=123193

It may help with your problem.

You can't use a function in the way that you want. Can you write the relevant values to a temporary table on the target server and then join to...

I was assuming that he needed to filter his results based on a table in the local database. Lets say that we need Nancies whose surnames match some list....

OPENQUERY runs on the target server and returns a result set to the local server. If you want to join tables across servers (and I think that is what...

I think there is some confusion going on here between Access and SQL Server.

The Access functions are MID() and INSTR().

The corresponding SQL functions are SUBSTRING() and CHARINDEX().

The same algorithm will...