You could perhaps just store the old/new pair of rows from the deleted/inserted tables also into a separate table, and use the triggercode for evaluating what has changed in the...

You'd have to do this in two steps, delete tableB first then tableA.

declare @deleteDate char(8)

set     @deleteDate = '20060207' -- <=== this is intentional format to avoid any and...

Do you want the 'where cnt > 0' to make the query to behave like the one where matches was required?

--for all rows in TableA regardless of

--matching...

Does the 4 seconds for the trigger also include sending the mail from within the trigger?

If that is the case, you may save some time by not sending mail from...

I think Ríchard has the solution. Using a tablevariable as intermediate cache within the transaction seems to be the way to go.

It works for a scenario like this: assume we...

Seems like this should work by just doing the update from a join..

update a

set    a.email = d.email

from   ActiveUsers a

join   Directory d

on     a.EmpID = d.EmpId

Would that work for you?

/Kenneth

I think that what you need is a 'destructive' collation that won't preserve accents and other 'fancy' notations, but just convert to the 'base charachter'... So I just tried a...

We really need scripts for your tables involved and also some scripted sample data that shows the effect you're having problems with so we can test your query.

(It doesn't have...

No problems Jeff (just had to google on 'recipro....' that wierd word.. )

If you feel like blowing off steam offline you're more than...

Yes, they are there, though there is two things about them.

First, it's a oneway encryption. You can't decrypt it once it's encrypted with those functions.

This may or may not be...

It seems like you're having some homegrown code receiving the results, perhaps something is amiss there?

How does it look in QA if you (important) log in as the exact same...

In SQL 2000 there isn't really anything built-in for this purpose.

In SQL 2005 I've seen some demos demonstrating how to encrypt and store - read and decrypt by using CLR...

Well, 'sometimes' isn't making it standard, so why stop saying how something 'should' be done..?

The fact remains, SQL sucks at row-by-row operations, doing it by hiding a loop in a UDF...

@david-2,

I do think this is the first time I've seen an inner, left and cross join all in the same query.

Testament to the infinite number of ways there is to...

It's basically the 'second step' of what you already had - a list of houses where any preference was matched.

The 'base query' gave you:

SELECT   o.obId, o.obName

FROM     @Obs...