tbaseflug
asked on
Insert into temp table - sp_executesql
I know that the below will not work - I will have no way of knowing how many columns may be in Table1 at any given time - so in theory - was trying to do something like the below???
DECLARE @sqlX nvarchar(max)
SET @sqlX = 'SELECT * FROM dbmasterdata.dbo.table1
SELECT *
INTO #tmpTable
FROM OPENQUERY(dataprod, 'EXEC sp_executesql @sqlX')
Why does it need to be so complicated and not just:
SELECT * INTO #tmpTable FROM dbmasterdata.dbo.table1
SELECT * FROM #tmpTable
Are you running against some linked server or something that you need OPENQUERY?
SELECT * INTO #tmpTable FROM dbmasterdata.dbo.table1
SELECT * FROM #tmpTable
Are you running against some linked server or something that you need OPENQUERY?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DECLARE @sqlX nvarchar(max)
SET @sqlX = 'SELECT * FROM dbmasterdata.dbo.table1'
SELECT *
INTO #tmpTable
FROM OPENQUERY(dataprod, @sqlX)