I had missed this one too.  Select @SomeVar from dbo.SomeTable is a valid sql statement that will scan the table.  I just thaught that this was a feature I had...

What was the problem?

you can add linked servers (sp_addlinkedserver) and use this select method :

Select *  linkedServerName.dbName.dbo.tblName  t1 inner join l1.db2.dbo.t2 t2 on ...

Select T1.ChildID Level1, T2.Childid AS Level2 FROM dbo.Table T1 LEFT OUTER JOIN dbo.Table T2 ON T1.ChildID = T2.ParentID where Parent = @id

Not tested but this should give you the idea.  If you want...

Doh!!!!!!!

Select @Something = SomeCol FROM dbo.MyTable

There's no where condition in this query, the server will HAVE TO SCAN to query the results. I think the programmer tried to invent a feature...

That would seem to answer it to me.

No step in the plan and faster code.  That would almost seem like a no brainer except for the fact that I've never...

The error may also come from a trigger (assuming this may not be a select statement).

That's one way to do things... I preffer my way .

You just add them to the where clause (if it's on the left table).  If it's on the joined table then you have to make it part of the join...

Yup, that's what happens when you want to help but don't have the time to test the final solution.

Who said that if you don't have time to do it right...

My exemple will work, just remove the go.

BTW this is why the code samples you post should also work when posted .

Not too sure of what you want to do nor what is the problem, but give this version a try!

use focintegra

declare @conta as varchar(15)

set @conta = '62103'

select @conta

go

update cpoo set

/*Base...

Please post some sample data from both tables and the required outout of the updated table.  The table ddl is also quite usefull to us.

I'd check in with the network guy, or the DBA that handles that server.  There must be something sucking the life right off that server.  My watch could update more...

Anything forbidding you to drop the table's data and insert all the data from the 2nd server?