@kevin, Thanks for your response. I managed to solve this, given below sample code.

INSERT INTO @mstab

SELECT [mId]

, [tId]

, [msDate]

FROM [dbo].[MS]

WHERE ([msName] NOT LIKE 'forecastedDate' AND [msName]...

Hi Riaan,

After a little struggle, I fixed the "The metadata could not be determined..." . I had to prefix the complete db and user name before the stored proc...

Hi Riaan,

INSERT INTO @temp VALUES

(

(SELECT * FROM OPENQUERY([INTL-DBSERVER], 'EXEC spGetCriticalGapsForATransition @transitionId = 1') FOR XML AUTO, ELEMENTS),

(SELECT * FROM OPENQUERY([INTL-DBSERVER], 'EXEC spGetCriticalIssuesForATransition @transitionId = 1') FOR XML AUTO, ELEMENTS)

);

select...

#Grasshopper, the compiler isnt happy. It fails at the first param of OPENQUERY itself.

DECLARE @server_name VARCHAR(100);

SELECT @server_name = @@SERVERNAME;

DECLARE @temp TABLE

(

Gaps XML,

Issues XML

)

INSERT INTO @temp VALUES

(

(SELECT *...

I'm looking for a similar solution, but instead of the 3 select statements, the values will come from 3 stored procs. I tried replacing the procs, get error.

INSERT...