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...

The BEST way to get date formatting is in the front end. 😛

If you must use sql than use Lynn's approach.

You have different numeric sizes in two different columns.

It is probably failing in the where clause.

What is the datatypes for bondTrade.TradeID and IRPTrade.TradeID? I am guessing these are both numeric...