Then how does Customer_ID relate to these tables. You told us he only common field names are

id (primary key)

transaction_date

communication_id

One thing I haven't seen asked is how big is your log file? Do you shrink it after the delete operation? If so what is you intitial size and growth factor?...

As stated INNER as you don't need to filter for NULL, as well only the records needed are pulled into memory on both sides and index can be used on...

Additionally how wide should be the largest number?

This is usally a memory issue not drive space. I have seen this on one of our heavily used servers numerous times until we redid several queries that were putting...

The quickest and best way to be sure you get it right in my opinion is this

Open Enterprise Manager and open the table (tablex since I don't have a name)...

Rereading this I realize you state can have the same date time for more than one record. Is there any other way to identify them in that scenario or do...

Sorry I never saw this happen so not sure. Did you try to reinstall the client tools?

You may be making overly complicated. Can you please post your DDL for the table and explain the relation is.

Otherwise let me make an example here and see if this...

I don't do the hiring, sorry.

OK so let's take a bit further with the assumption of a Users table.

DECLARE @CategoryID INT -- SHOULD BE A PARAMETER

SET @CategoryID = 1

SELECT

 TOP 5

 JokeID,

 JokeCatID,

 JokeTitle,

 JokeDesc

 UserID

FROM

 dbo.Jokes C

INNER JOIN

 (SELECT

   --UserID, -- Uncomment...

Always busy these days. Try to pop out every so often.

I would add a column for Inactive Date or something and allow it to be null. The make the Uniqeu Constraint

Col1, Col2 and InactiveDate

this will allow you to have...

Glad to help. Also just realized, I am sure you have a Users table of some kind which means you can change this line to

(SELECT DISTINCT UserID FROM dbo.Jokes)  A) D

to something...

Although the method used generally does work I have performed a script where a table was changed the way EM does it. After completion the table was gone. So make...