I ran the following query:

DECLARE @tsql VARCHAR(8000)

SET @tsql = '

SELECT

E.UCELL_ID As LocalCellID

,RNC As RNC

,Cast( Cast(YEAR_ID As varchar(4)) + ''-'' + Cast(MONTH_ID As varchar(2)) + ''-'' + Cast(DAY_ID As varchar(2))...

The query above gave the following error:

Incorrect syntax near the keyword 'OPENROWSET'.

Hi Chris,

I had run the original query yesterday with OpenQuery Status= Active filter to check the result , its still running after 23 hrs 🙁

I'm waiting for it to...

Sure Chris, I'll try this right away.

I would like to share a new learning I made today , earlier when I was trying to run the query with OPENQUERY command...

Hi Chris,

The query I attached is defined and saved as a procedure and there is a job defined which executes this procedure daily. Are you referring that this procedure should...

Thanks Lutz for the recommendation...Can you please send the steps or the final query to run.

As it is the production server I'm not allowed to make frequent changes. Also starting...

Hi,

As I mentioned in my earlier post while running with OpenQuery gives me the following error:

The OLE DB provider "SAOLEDB.11" for linked server "ENIQSQLSERVER" supplied inconsistent metadata. The object "(user...

attachment uploaded

Thanks for the suggestions.

I have attached the query as attachment name "main query" which takes time.

Also I modified the query with open query and ran on the server which gave...

Thanks Lowell and Scott for the reply.

Please help me with following queries:

1. Where and how can we access and check the temp table .

2. Why is Linked servers required.

3. And...

Hi ,

I have attached the execution plans for the 2 servers here :

1. Mum plan (Server with better performance of 6 hr)

2. Del plan (I ran this one yesterday but...

Thanks Craig and Chris for the reply,

I have run the query on both the servers will post the execution plan once it runs, normally when running the same query independently...