Thanks guys,

Just can't get the columns corrected columnized. I mean, what seperator should I use in this case?

Thank you.

Thanks for your quick response, but I need table in the return.

😀

I was hoping to move this post a little bit further on the top in the forum so people won't miss it.

up

I am doing this through SSMS, there is no local SSMS on the server.

You must be guessing the credential I used to connect to the server, however, this is the...

Please forget my last post, I already figured it out. Thanks anyway.

But this might not be the good one though.

select

b.divisionname,...

Here is my final query:

;with Breakdown as

(select divisionname, avg(averagescore) as AverageScore,

case

...

Thank you so much. It's amazingly working.

The sp is out of my control, it returns too many columns, I just don't want to manually create replicate those columns on my side, and I might need to...

Hold on a second, not finished yet.

I am able to perform:

EXEC CHRGBKP2NT.CBReports.[dbo].[spBNS_MappedServerWithIPV2] '2008-08'

with enabling RPC, However, when I tried this, I still got error message:

select * into #temp from

OPENROWSET

(

'SQLOLEDB.1',

'Data Source=CHRGBKP2NT;Initial...

Jack,

I thought Enabling RPC is a job of admin of the remote server, I didn't know it can be done on my side.

Thank you, working perfectly now.

When I tried to run the sp using the 4 part naming convention, it gives me:

Msg 7411, Level 16, State 1, Line 1

Server 'CHRGBKP2NT' is not configured for RPC.

Other people don't...

Hey Bob,

You know what? your original ( :hehe:, yes, the one you once deleted) suggestion is better for me in this case, performance is not an issue at all.

Thank you.