Can you post what you have so far?

Frank,

From BOL:

Use the affinity mask option to increase performance on symmetric multiprocessor (SMP) systems (with more than four microprocessors) operating under heavy load.

-----------------------------------------------------

And yes it assign the Highest Processor...

I am sorry to disappoint you but

select * from (select * from tblCompSR_cross) q

WORKS!

Your Locks are caused by SELECT INTO!

Change it to

Create Table #temp_table(Fld1,Fld2)  Select Fld1,Fld2...From HDRGL_DATA

I don't get what you are trying to say but...I was joking about a view called complications

What is the problem with the query? And even though you have a massive...

Once again:

Can you post the code?

I have been able to run an ALTER on some production sp (with the same code, of course) and those were recompiled on the spot. What is even more you could...

Can you post the code on those procs?

It will be a wild guess to figure it out without further information

Yep,

Full outer is appropriate for 2 tables, Three or more you have to go the Union Route:

select IDS.Id as comp_prid, ....

from

 (select LV_PrID as Id tblCompLV_cross 

 union

 select LN_PrID tblCompLN_cross ...

One thing though you should write the insert as:

INSERT INTO #ultimate_parent_sector(ac_symbol, issuer_id, ultimate_sector)

EXEC dbo.ultimate_parent_sector_override_set @BusinessDate

The Field List should be specified!

The 'dbo' is a little...

>>SP2 gets locked when SP1 starts Executing SP2<<

SP2 Must be locked by something else than SP1 otherwise if you are READING #Temp_Table Try:

Select * from #Temp_Table with (noLock)

 I have use...

The shortest path is Uninstall/Reinstall (Easier than any other route)

For confirmation http://support.microsoft.com/kb/260414/en-us

Create Table Contacts( name varchar(200))

 go

 insert into Contacts(Name) Values('John E. Doe')

 insert into Contacts(Name) Values('Jan Smith')

 insert into Contacts(Name) Values('Ralph Wallace')

 insert into Contacts(Name) Values('Walter C Johnson')

go

select    Left(Name, Len(Name) - Charindex(' ',Reverse(Name),1)-1) As FName

 ,...

Actually I have to take that Back! My mistake!

It should have been ansi_nulls should always be set to ON.  And the reason I posted that...

It will be VERY helpful if you post the DDL of the tables and Columns involved

but here is a hint

Update a set aggregateOnA = DSum.TheSum

From TableA a

     join...