Just populate your table with 500k dummy orders having 5 lines per order (quite typical number for 3-4 years old systems) and try to perform 1st option.

Decide for yourself if...

Posting the query would be useful.

But general suggestion - apply COLLATE inside equation:

WHERE SomeCal COLLATE ... = AnotherVal COLLATE ...

SELECT LEFT(@Var, @Position -1) + '?' + SUBSTRING(@Var, @Position + 1, LEN(@Var) - @Position)

If you perform such insert using INSTEAD IF trigger on a view it will become auto transaction.

Anything fails inside of transaction - and everything rolls back. Whole insert.

No need to...

Set a clustered index on the column(s) mentioned in ORDER BY.

David, you did not answer the question:

When the even suppise to happen to be named by you "midnight event"?

Exectly at midnight?

Not 1s later?

Not 1 ms later?

Not 1 mcs later?

What if...

> Database is usually the bottleneck right? [Wink]

Not really. Only if it's designed badly.

In my last project test with 400 users simultaneously accessing database revealed that internet traffic was a...

David, there was a question buried in tons of spam:

What would you name a "midnight event"?

What does it mean for you: this happened at 00:00?

100 replies.

Whoo-hoo!

And if to consider that this topic was started as an extension to another one, also quite long...

And I don't what your B.S. degree is worth but you perception of business practices is just wrong.

In tax reports if intermediate results must be included in report

TotalTax should...

They have at least something in common:

- they based on wrong assumptions;

- they were proven by some people (by you in case of BR) using big names of big authorities....

> Sorry, it worked,

Sorry, it did not work.

Everyone can see it.

> was approved by the accountants, and the auditors, and for this company is a part of their business...

"Once again you manage bring up something that has nothing to do with the subject at hand."

Or now you're trying to prove that Bankers Rounding is invalid?

Don't bother, I know...

> ... IBM, IEEE, Microsoft, about every signal processor manufacturer in the world, the PLC manufacturing industry, and just about anyone else who matters.

Once again you manage bring up...

Once again, for really "smart" people with big diplomas:

I ready to admit anything you can prove.

As soon as you cannot prove validity of Bankers Rounding there is nothing to admit...