If there is no primary key in either table, how can you determine whether two records are "the same". Do you have to compare all of the columns one by...

Where do you want to use it?

It's not available in Access SQL (AFAIK), but it is available in VBA. Or if you use a passthru query to a SQL Server...

You need to qualify your names further when accessing other servers.

Try using servername.DB1.dbo.Table1

It's not hard.

insert into tablename(fieldname1, fieldname2, updatedfield, ..., fieldnamen)

select fieldname1, fieldname2, 'zzz', ..., fieldnamen

from tablename

each time you run it, it doubles the size of your table.

Before we go into the actual query required to do this, I suggest that you think further about architecture. Surely you don't want separate first- and last-name tables? Separate columns...

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.