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

How do you know who wrote it? I don't see...