This problem is almost certainly due to parameter sniffing. Gail has a good article on Parameter Sniffing[/url]

There are other issues with your code, though. You should use a...

You've been around long enough that you should know that we're going to ask for DDL, sample data, and the actual execution plan.

I think that part of the problem is...

You should be using sp_executesql rather than EXEC. BOL has examples of using parameters including OUTPUT parameters.

Drew

Let me guess. This is the same query where you replaced a CURSOR...

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

I am calling 5-6...

Eugene Elutin (5/9/2012)

---

So far OP failed to present enough details about required output to...

Without sample data, it's hard to tell what the problem is. Here is what I suspect is happening. Your TableA has multiple procedures for a given unit, some...

vinu512 (5/8/2012)

Todd's Logic is very nice. Didn't hit me when I was trying it.

But it was just lacking something.

I tweaked it a little and got it working. 😀 Here's how...

I think that T-SQL is simply the wrong tool for this particular job. T-SQL is designed to optimize transactional processing. While you can do basic analytical processing in...

Sean Lange (5/8/2012)

---

With 526 points I would think you would know you should provide a bit more detail than this. This is totally a shot in the twilight.

update pjprojex

set rev_type...

The key is to understand that there aren't 52 weeks in your year, but rather 52.2 weeks rounded down (truncated).

Try the following

MyCount = Round(datediff(day, @CalendarStartDate, CalendarDate) / (7 * 52.2...

anthony.green (5/8/2012)

---

it is substituting 0 with the default date of '1900-01-01 00:00:00.000'

If only a time value is assigned to a variable of a date data type, the value of the...

This will produce what you are looking for, but I agree with Eugene that the reasons for producing this result are suspect.

SELECT STUFF(( SELECT ', ' + field2 FROM #Tbl...

If you have enough units of measure, you'll probably want to create a conversion table instead of using the CASE Statement. Something like the following.

DECLARE @Sample TABLE

(origin_code char(5) NOT...

If it's so clear,...