Quick thought, there is something missing in the code, check that all variables are declared and initialized.

😎

Hi and welcome to the forum. Could you do us a favor and post a create table script and some sample data, makes it much easier to answer your question.

😎

Nice question Stewart, thank you for this.

😎

crazy_new (9/3/2014)

---

Just a quick scan, you have an update table, which is the same table I am deleting and inserting to, I cant update because there are no unique identifiers....

Did a quick little testing, see the results, DDL, data generator and test code below. Code also attached.

Feel free to play around and improve 😉

😎

-----------------------------------------------------------------------------------

Dense set: 1000000 (10000 customers x...

Koen Verbeeck (9/3/2014)

---

And even more important,...

Think that here is a proper use for a TERMINATOR:-D

😎

Are you working for Skynet?

😎

ppritts (9/2/2014)

---

I had an SSIS Package that took data from a flat file and moved it into a SQL Server table. It was working OK, but I had to add...

Lynn Pettis (9/2/2014)

---

I...

😎

crazy_new (9/2/2014)

---

Just a quick question. In the inserted/deleted tables, does it contain all of the records of the last single transaction made? And if I use set based logic,...

As I said...

Ed Wagner (9/2/2014)

---

Thanks, but I guess...

Further on the previous solution, here is an executable sample

😎

USE tempdb;

GO

;WITH BASE_DATA(NNAME,NGROUP) AS

(SELECT NNAME,NGROUP FROM (VALUES

('Bill','Finance')

,('Nancy','Ops')

,('Bill','IT')

...