It's late on a Friday. Someone on another forum just pointed out to me that I wasn't doing a SELECT on my temp table after I built it. I'm going...

I tried to post the entire stored proc, but something in it was causing a problem with the forum. I suspect it's either the table creation or dropping or the...

No, LitHold and LitHoldDetails are in a one-to-many relationship, but LitHoldDetails and EmailTemplate are in a one-to-one relationship. For every LitHoldDetails, there is one (or should be one) EmailTemplate. My...

LitHold and LitHoldDetails are connected via the LitHoldID column, and LitHoldDetails and EmailTemplate are connected via the LitHoldDetailsID column. Apart from that and the table structures, what else do you...

Ah! I knew why I was getting the error message, but using TOP never occurred to me. However, I think there's still something wrong. With the new query:

insert into EmailTemplate

(LitHoldDetailsID,...

As it turns out, this was so simple and obvious I'm embarrassed. :blush: Here's my code:

DECLARE @EmployeeIDs TABLE(FirstName VARCHAR(30), LastName VARCHAR(30), PhoneNumber VARCHAR(50), Title VARCHAR(50), EmployeeID VARCHAR(6), Location VARCHAR(30))

INSERT INTO...

Thank you, Vinu! The EXCEPT statement is new to me. Always nice to learn something new.

I believe this does it.

Thanks, Steve!

OK, sorry, let me try to explain more fully. The Action Table contains actions that need to be completed for each Item and the person responsible for taking the action....

I figured it out! Thanks to this link, I changed all the ORs to UNIONs. My query now runs in less than one second. :smooooth:

FYI, I tried implementing Full Text Indexing, but it had no effect on the time the query takes to return results. In some cases it takes longer. We also looked...

😀 Are law firms always so ridiculous? Never mind, I've worked at them since 1987, I know the answer. Email is only part of the data we need to trawl...

Thanks again.

Thank you. How about FULL TEXT searching? Microsoft says it's faster than the equivalent LIKE statements. I've never used it. Is it worth looking into in this case?

Thanks! Can you suggest an app or two that would be appropriate?