Sure... but would you only work for people that knew what it meant?

Agreed. Jeff has a way with cutting to the chase and seeing what is really needed.

I think that this article will help you out: Delimited Split Function[/url]

kr.nithin (6/10/2011)

---

Thanks for the help provided. I figured out the problem. There was data type mismatch , hence the issue.

I have another issue:

I want to update only those values...

flyingrockfishguy (6/10/2011)

---

I made a small syntax error in this query, and would have expected an error when I tried to run it. The results are quite interesting.

SELECT ExtraValue,VendorID

Employee,...

:blush:

Thanks Jeff!

Maybe, maybe not. We're still learning from you, and I'm hoping that you'll keep on posting so I can keep on learning.

(Congrats on the 25k. )

Tony,

Well, I can't think of any other way to optimize this. I think that this leaves you with two choices:

1. Use the iTVF. Pros: same code is used by two...

Just making sure you're looking at the code as a sanity check! :w00t:

Does this index...

Tony,

Starting over. The main (not single) procedure is totally rewritten to combine the TVF with it. If this works, we'll combine the TVF into the single procedure also.

Start off by...

tfeuz (6/8/2011)

---

WayneS (6/7/2011)

---

tfeuz (6/7/2011)

---

Wayne,

I had to make a fix to the code -- you did not constrain by the rule id when you create the temp table -- it caused...

Tony:

Is RB_InvoicesToProcess 1:1 with Invoices?

Is RB_InvoicesToProcess_Moved 1:1 with Invoices?

Just to verify, you can have the same invoice in both of those tables?

Ah, so you were. I heard it went pretty well.

As long as they have fairly uniform...

tfeuz (6/7/2011)

---

Wayne,

I had to make a fix to the code -- you did not constrain by the rule id when you create the temp table -- it caused duplicate values...

Note...

TheSQLGuru (6/7/2011)

---

I applaud you Wayne for thinking outside the box on this with a switch to an mTVF. I am sure you aware that the optimizer can no integrage...