No probs & good luck.

Try this:

INSERT INTO gooddate

([orderdate])

select

CONVERT(VARCHAR(50), CAST(nullif(orderdate, '00-XXX-00') AS DATETIME), 101)[orderdate]

from baddate

It should fix the problem, provided you are prepared to live with the fact that your SELECT might read data from uncommitted transactions that may be rolled back.

I also suggest an additional condition to avoid updating any customer names that are already correct, on the basis that reads are way faster than writes:

update nr1

set CustomerName = c.CustomerName

from...

If you want all of this data in a single Excel worksheet in a format that makes any kind of sense, you have to decide on a maximum number of...

Assuming street1 and street2 are tables, this method does a cross join and then orders by the sum of the absolute differences in x and y coordinates, selecting the lowest....

Dennis

.mdf and .ldf files are not backup files, they are native SQL Server database and log files respectively. All you need to do is copy the files to your standard...

OK - so what is the relationship between T1 and T2? Do you just want them displayed side-by-side in ascending order?

Please describe how to get from your sample data to your required results. Where did the 100 and 200 come from?

I don't think so. You'll have to change your logic to move your DBCC statement out of the transaction somehow.

Not sure. Could you do something like

osql /L > sqlservers.txt

to redirect the output to a file called sqlservers.txt and then use that in your app?

SQL 200 - that must have been a while ago

Have you tried installing EM on another PC and seeing whether it happens there...

What is your question?

Creating and deleting tables uses resources, of course, and this is an unusual way of designing an application.

Whether this starts to cause you performance problems depends on volumes, hardware, how...

Well, I guess you could try this.

First off, replace all of the single quotes with something else - eg ~ or some other character that does not exist elsewhere in...