Don't remove the primary key unless you really really know what you are doing! The PK is there to enforce uniqueness between the records in the table - if you...

It looks from your post as if new tables are created every day - possibly with identical formats, and presumably storing data applicable to that day?

It's probably a major change...

OK, will try your (more helpful) syntax.

I was on the server (via RDP) and I was logged in as the SQL Agent service user when I got the error, so...

What's the query doing? Any cross-server stuff? Could it be a security issue (is your task running as a local user)?

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....