Did you notice that...

Well, the MERGE statement does support updates, inserts and deletes all at once. And common-table-expressions (CTE). Between the two, you should be able to get it done with one very...

If I'm understanding this correctly, 'spreadsheet2' had an external data link to grab data from 'spreadsheet1'. Is this correct?

If so, why do you need to worry about sending it out...

Thanks Elliott - I KNEW I...

For the title of the thread, how does this work?

select *

from sys.databases --(or dbo.sysdatabases for SQL 2000)

where name like 'ReportServer%'

e1785 (8/25/2010)

Well, the values to be...

The joining on the delete would go like this:

DECLARE @TempTable TABLE (col1 char(1), col2 int);

INSERT INTO @TempTable

select 'A',1 UNION ALL

SELECT 'A',2 UNION ALL

SELECT 'A',3 UNION ALL

SELECT 'A',4 UNION ALL

SELECT 'B',1...

sp_addserver 'NewServerName', 'local'

You must shut down and restart the server.

You might consider writing this out as a CSV file - Excel will directly import it.

You won't be able to do this with the Jet engine on 64-bit.

I thought I had read somewhere about a month ago that there is now a 64-bit driver for...

emailcooney (8/25/2010)

CREATE TABLE tblCompeditors (CompID AutoIncrement,MemberID TEXT(100),FirstName text(100),LastName TEXT(100),Address1 TEXT(100),Address2 TEXT(100),Town TEXT(100),County TEXT(100),PostCode Text(15),Phone Byte,Email TEXT(100),Sex TEXT(10),DOB Date,Club TEXT(100))

CREATE...

Hah! Read my reply...

Would you mind posting the name of the bank? I suddenly sense a need to move my accounts! :w00t:

Have not attempted to change the server name.

2nd link: does not appear to apply (can't even...

Here's my two cents ... Until you...