I have a stored procedure that queries a linked DB2 server in this fashion:
SET @sql='SELECT * FROM openquery(DB2,''SELECT column1, column2 FROM table'')' exec sp_executesql @sql
I am trying to store that result into a new table via another stored procedure
INSERT INTO [schema].[Table] ([column1] ,[column2]) EXEC('schema.StoredProc')
Where StoredProc contains the aforementioned openquery
However, when I execute the second Stored Procedure (INSERT INTO), the output window prints out the text of @sql from my first stored procedure, and gives me the message:
SELECT * FROM openquery(DB2,'SELECT column1, column2 FROM table') Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Any help is appreciated