Your question is not very clear. I can however suggest a much fast string splitting function than the xml based version you posted. Take a look at the string splitter...

Hands down your best approach is to get rid of the cursors all together. Then you don't have to worry as much about performance issues like you are having. Are...

Poor indexes, stale statistics, parameter sniffing could be any or all of those plus a zillion other reasons. My best guess is periodic performance issues. If you want some help...

vinu512 (5/9/2012)

---

I was just pointing out...

Perry Whittle (5/10/2012)

---

hisakimatama (5/9/2012)

---

I'm not sure what the distinction is there, Perry; I'm assuming Windows form would mean something coded in a language such as Java, C#, C++, etc.? ...

Lynn Pettis (5/9/2012)

---

Okay, I know that there was a recent forum thread about upper and lower case keywords. The last post had a link to a site that could...

Putts (5/9/2012)

---

You are just making statements now with no backing.

What is the point of a table-valued UDF if not to return a resultset? Is that not the same...

Lynn Pettis (5/9/2012)

---

Sean Lange (5/9/2012)

---

WayneS (5/9/2012)

---

capn.hector (5/9/2012)

---

Lynn Pettis (5/9/2012)

---

riya_dave (5/9/2012)

---

hi

i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it...

WayneS (5/9/2012)

---

capn.hector (5/9/2012)

---

Lynn Pettis (5/9/2012)

---

riya_dave (5/9/2012)

---

hi

i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than...

cphite (5/9/2012)

---

Putts (5/9/2012)

---

Currently, our Data Access relies heavily on SPs - we do not call Tables or Views directly from code. If we have a reason to query the...

hisakimatama (5/9/2012)

---

Thank you for the replies.

Sean, I'm not sure if it helps or not. The code above is exactly how the procedure is stored and called from within the...

If this is a parameterized proc this should be ok. Does the procedure code look like this?

create procedure SomeProc

(

@Counter2 int,

@ItemCode2 nvarchar(30)

) as...

This thread is in the sql 2000 section. Can't use CLR. Not to mention this thread is 7 years old. 😉

I am willing and able to help but your description is very unclear. Can you post exactly what you want for desired output from your sample data?

I have no idea. I can't see your tables and I am not at all familiar with your system or data. I was simply offering a suggestion of where to...