Sean Lange (8/1/2012)

---

What you have is a MASSIVE improvement over the cursor/looping you had originally. Assuming this produces the desired results I think you have something you can take back...

I updated this query withouth using loops. Its the same stored procedure from before, just reworked. It would be great if you guys could give me some input, thanks.

-->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>...

Jeff Moden (7/31/2012)

---

morepainot (7/30/2012)

---

Im here back at the office...

...{snip}...

Ok Sean, I understand the irony behind all of this but yes I am in over my head. I have re-worked this...

Sean Lange (7/30/2012)

---

Alright Jeff, thanks! Im here back at the office and I am trying to change the loops into the code you have given me. I cant seem to...

Jeff Moden (7/29/2012)

---

Wow, thanks a lot Jeff!I know you advised me against looping from the beginning but after I talked to one of their senior developers he said looping was...

Jeff Moden (7/27/2012)

---

Sorry for my previous mis-post. I forgot that you were trying to add messages to each extracted row.

First, a bit of an explanation about the first section...

Sean Lange (7/27/2012)

---

Lynn Pettis (7/27/2012)

---

Sean Lange (7/27/2012)

---

Jeff Moden (7/27/2012)

---

Tell them what you told me in the email...

I cant tell if you guys are being sarcastic or not...

//**UPDATE**//

Here is the query WITHOUT CURSOR. I used the LOOP but looks like I have too many temp tables and I need re-create this in a better format. The purpose...

I have no problem using CURSOR, as you can see by my original script. The people who have contracted have the problem with CURSOR. I dont care about using either...

Jeff and Sivaj, thank you guys for your help.

@jeff; I understand what you said and I will keep that in mind for the next post. The reason for...