DOCTOR FRANKENSTEIN

OPEN UP !

Why would you even want to do this in a single statement ?

For data integrity ?

Then you can place the 10 delete statements within a transaction.

It can't be so hard...

Now,

69% of reponses were right (UNION ALL).

So, peasants, let's organize. Pick up your torches and pitchforks and let's all walk up to Frankenstein's castle!

Sorry - you were wrong

No. YOU ARE wrong.

It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.

So "UNION ALL" is...

Missing form my post:

I had put "your first step" between the " " characters and this had the effect of ripping out anything between these characters.

So, [font="Courier New"]EXECUTE @r =...

OK, makes more sense now.

To me table [font="Courier New"]Employee[/font] meant a list of employees with basic data:

[font="Courier New"]CREATE TABLE Employee

....(

........EmployeeID int NOT NULL PRIMARY KEY IDENTITY,

........EmployeeCode varchar(8),

........Family_Name varchar(30),

........Given_Name varchar(30),

........Other_Name varchar(30),

........Date_Hired...

The old-fashioned way of doing this.

Obviously, 5,000 lines of cocde mean that there a lot of consecutive, distinct steps in the processing.

Start with the first block, enter it in something...

Er...

What kind of an organization has an Employee table with 30 million records in the first place ?

As for obtaining a list of which records were updated, you do not...

Gila,

I posted this because I thought that seriously, the gimme types would have probably missed Dan's point.

This is getting ridiculous.

An author proposes one of his books and someone expects to have it for free ?

Why on earth would anyone bother with writing books if the author...

Never used CLR yet. This was supposed to be the greatest thing since sliced bread.

Jeff, would you please enlighten me as to why CLR is viewed as a bad idea...

Using "INDEX(0)" is a later manifestation of the code... don't need to know the name of the clustered index that way and that allows you to easily use this on...

To: Davroche.

We all started as newbies and the forum is great in that respect, helping others.

Do not take this wrong:

1. We enjoy helping others as others helped us, not...

ggraber:

If you are using SQL Server Management Studio, simply right click on the table, select 'Script Table As', select 'Create To', select 'New Query Editor Window'

I have not used the...

rbarryyoung: (p.s. This is "Humor" also.)

Now, that's funny!