I would drop that function entirely. It is about the worst performing methods of splitting strings. Take a look at the string splitter article referenced in my signature.

Secondly I would...

ChrisM@Work (8/23/2012)

---

Nobody is laughing at you. Some of the folks who have responded on this thread may at...

I got this correct for all the wrong reasons. I didn't have a clue what the point of the question was but since the variable, temp table, and persistent table...

That is because you changed the not in to exists. Exists does not work like that. It evaluates to true or false and does the action accordingly. You should change...

Evil Kraig F (8/22/2012)

---

That. Is. ...

dcwilson2009 (8/22/2012)

---

Thank you for your quick reply. I would just want to put them both into the error table, maybe even with a different error description. It's impossible to evaluate...

It doesn't matter which side, it is going to force a scan...

lallu_jaya (8/22/2012)

---

@sean-2 Lange

Iam having multiple values for test_status which I didnt mention in my 1st post.

I am having other status like rerun, non completed, investigate etc which I want to...

dcwilson2009 (8/22/2012)

---

Thank you very much - we are very close now. But what if there are duplicates in the source - not counting the target? How do we get those...

Michael Valentine Jones (8/22/2012)

---

This is one of my all time favorite threads about an EVA:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61024

I especially like the query posted by RobWafle at 02/01/2006 12:05:48 that had over 40 left...

sqlfriends (8/22/2012)

---

I would like my query to be sargable.

So what other...

lallu_jaya (8/22/2012)

---

I have a temp table where Iam inserting data from original table

temp_id, temp_test_id, temp_status

1 2 ...

Holy cow!!! You have 9 points and your post was absolutely perfect!!! It included all the ddl, sample data, desired output, a clear explanation of what you wanted. I wish...

Lynn Pettis (8/22/2012)

---

Evil Kraig F (8/22/2012)

---

Lynn Pettis (8/22/2012)

---

I'm going to go against the flow a bit here. I think it really depends on what the application is intended to...

sqlfriends (8/22/2012)

---

I use the merge statement in a sproc to insert, update and delete records from a staging table to a production table.

In the long sql, here is a part...