is [fINAL cOMPONENT] indexed in the look up table? IF not, index it. That should change the scan to a seek.

You can choose the dataset when you choose the field for the operation. It can be any dataset (and any field in that dataset) that is available.

Nice!

Your second approach is the best one. Execute it in sections and see if you can isolate where the failure occurs.

Is there a problem to install the service pack?

1. Ensure that the columns in your join predicates and WHERE predicates are indexed.

2. The RID Lookup (Heap) says to me that the lookup table has no Clustered Index. ...

The temp table in the dynamic sql is created in a different context and not available to the calling context. e.g.

DECLARE @sql nvarchar(4000) = N'create table #foo(a int)';

EXEC sp_executesql @sql

SELECT...

adonetok (11/13/2014)

---

In one store procedure I do insert same data into two tables (They have the same structure): OrderA and OrderB

insert into OrderA select * from OrderTemp

insert into OrderB select...

well one sure-fire method is to disable the super user and see who complains

sharonsql2013 (11/13/2014)

---

I want to use an expression where the indicator should only select one of the three values as the data has lot of NULLS and I don't want it...

THink about this:

You refer to @MemberIds in two different ways:

where

C1017.v_Member.MemberId IN (@MemberIds) and

-- and

@MemberIds = C1017.v_Member.MemberId

Now, if @MemberIds is a single value, this will work, but what if it...

declare @t table (Col1 char(2), col2 char(2),col3 char(2))

INSERT INTO @t (col1, col2, col3) VALUES

('AB' , 'BC' ,'DA')

SELECT a AS [Values], x.val AS HardCoded

FROM @t

unpivot (a for col in (col1, col2,...

robolance (11/13/2014)

---

I am tuning a very long and slow running process.

Somewhere in the past I heard/saw a discussion about how indexes are handled when using an 'IN' vs....

No difference in results for inner join. It's a matter of style. Matching vs filtering. Usually put matching in ON clause and filtering in WHERE clause. ...

How about:

CASE WHEN PlannedRequirement.MIN_keydate IS NULL

THEN SELECT MIN(KeyDate)

...