I would like to create a temp table from a openquery. like the following
declare @sql varchar(1000)
select @sql = 'select * into #Temp from openquery(Oracle server name, ''select count(*) from SomeTable'')'
select * from #Temp
I got a error message saying Invalid object name '#Temp'.
Please help. Thank you!