SSMS Results

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Modify the script to dump the results of each query to a temp table and then finish with a select from the temp table.

BSavoie SSCertifiable Points: 6309 More actions · Answer 2

Thanks for the response Jack!

So create the temp table in the the shell that executes the remote script, or in the remote script that gets executed? I hope that makes sense.

.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

I'd do it like this:

Create Table #results(...)

Insert into #results

Select ... from local table

Insert into #results

Select ... from linked table

....

Select * from #results

BSavoie SSCertifiable Points: 6309 More actions · Answer 4

Here's some psuedo code of what I'm doing

set @SqlTxt = 'select SomeCol from SomeTable'

select SvrName from syssevers

while SvrName is not null

begin

exec(@SqlTxt) AT [SvrName]

select next SvrName

end

The exec is really executing on a remote server. Where would I create the temp table in this scenario? Inside the exec?

Thanks!

.