The replies and the insight into the future is pretty encouraging and clear. I discussed with my friend about the transition from development to DBA and most of...

the query is using linked server. but if i execute without the linked server directly on the server it works fine.

select orderguid from [cc-datamart-pro].scmprod.dbo.cv3orderuserdata

where touchedwhen...

UPDATE dbo.eyecare_customer_call_summary

SET dbo.eyecare_customer_call_summary.required_calls = eyecare_customer_call_summary_1.required_calls

FROM dbo.eyecare_customer_call_summary

JOIN ...

please give us a clear description if you want the problem to be solved.

I do not understand even a single thing to ask questions to solve the problem.

It looks...

Select top 20 * from Database1..MY_TABLE (nolock)

Where THE_ID = (Select THE_ID from Database2..MY_TABLE_2 Where OTHER_FIELD = 'VALUE')

Order By MY_COL desc

Now....the subquery is invalid, there is no column THE_ID on Database2..MY_TABLE_2.

But...