I hate to point out the bleedin' obvious, but why on Earth would you have a QA environment that is different from your production environment?? Isn't the point of a...

Please provide us with the code you use for your update.

Based on what you are writing just now, I assume you use a correlated subquery?

B

Create yourself a DIM_DATE table (I still wonder why a lot of people don't have such a table as a default) and then run the following code in your SP

SELECT...

:blush: .. thanks for the correction GilaMonster

😀 ... I certainly was not suggesting such a radical step! - but I'm stuck at...

For Information purposes only, copy/pasted your SQL and then added FROM dual; at the end to run it in Oracle and got the right answer without any further manipulations:

4020.73315

(running Oracle...

The appropriate locking should take place by default - you can provide hints if you wish to lock objects at different levels (row, page, table), and you can force queries...

I'm with CELKO - use a calendar table, then you can count your Sundays, weekends, Easter Mondays and whatever else you need between two dates - much much easier, and...

Error ID 10048 occurs when the port you are connecting to is being used by some other application.

In your case, it may be the same application, but at nearly the...

I would go back to basics on this.

If you can, copy your MSAccess app as a new file, zap everything but the code you are interested in - in that...

Not knowing what OS we are talking about, I will assume that the machine runs with Windows Server 2003+.

Have a look in the windows event log (http://support.microsoft.com/kb/308427), a number of...

Have you tried turning the IDENTITY_INSERT to ON?

Essentially it is to be able to ensure that all database transactions can be processed reliably. It sticks to the ACID concept (atomicity, consistency, isolation, durability).

Below shamessly copy/pasted from wikipedia...

Hi,

Do you have access to the machine hosting the SQL Server DB? if so, can you check on there for the windows log, and sql serror logs?

See if there is...

Bhuvnesh

---

i dont think , it only depends if the any one Non clustrered indexe has all columns from SELECT part plus where clause , other wise there could be key...