CREATE PROCEDURE dbo.usp_sc_customer_tx

@I InsertIDs READONLY,

@C ClearIDs READONLY, ...

Fair enough, Lutz. ...

OKAY... once more from the top. In the example below, there are either one or two rows in the source table, but each have the same GUID...

MUCH clearer, to me at least. I'm glad you found a workable solution. 🙂

There is nothing wrong with the NOT EXISTS syntax that the LEFT JOIN is going to cure. That's just another technique for doing the same non-existence test....

Eric, in the absence of sample data, I'm going to hazard an opinion. You have a join at some point that is causing multiple rows with the same...

Yes you are doing something wrong. You are failing to punctuate. This makes your questions and comments all run together and is discouraging to people who are...

Here it is. Like the pivot, it avoids the index seek required by the NOT EXISTS. The execution plans appear to be close, if...

Did you not even look at my example casting an integer as SQL_VARIANT datatype?

This one is more basic. It only shows the list of patients. However it produces a nice execution plan if we can assume that there...

Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

This is exactly what I needed to know. Thanks for bringing...

The world is grey, the mountains old.

The forge's fire is ashen-cold.

No harp is rung, no hammer falls.

The darkness dwells...

We still don't know what results you are expecting, so we are unlikely to be of any more assistance. At this point, I don't even know why you...

Paul, I have to ask just when is Windows collation used?

I would assume that since all the work is being done inside SQL that some default SQL...