Mayank Khatri (5/27/2009)

U do have to use table variables, and then...

Turns out my IT department was giving me the wrong linked server name. I am only using this to pull data - I don't need to manipulate it at...

So I got a response from my IT, and tried:

select name from [aka_cssrepl].[Master].[sys].[databases]

However, this time the error message is:

Server: Msg 7416, Level 16, State 1, Line 1

Access to the remote...

😀 Excellent - if this works, it will world shaking for my department.

Thank you so much for your help. If anything develops, I'll be back.

Getting a lot closer. THANKS!

select name from [AKA_LEOPARD].[Master].[sys].[databases]

What I got from that was:

The OLE DB provider "SQLNCLI" for linked server "AKA_LEOPARD" does not contain the table ""Master"."sys"."databases"". The table...

That worked, but came up with zero results.

I also tried sp_linkedservers - and that came up with a good size list, but I can't tell what servers are being linked.

Now I am wondering if one is already set up, and I just don't know about it (or anyone else in my area). Is there a little script I...

I'm thinking about trying to get permission from the IT department. Is linking servers something I do once, then run my queries all I want - or do I...

Thanks for the information, but sadly I do not have the permission to perform such an action. Any way around this (other than getting the premission, which is slim)?

Well, ultimately I do neet acct_num. The purpose of the query is that I want to get a list of each unique capacity, secy_type, and record_type combination, then pull...

Thanks guys,

I'm totally indifferent on which row the query chooses when capacity, secy_type, and record_type is the same - that's why I was hoping SELECT TOP 1 would work.

Hope that...

Thanks! Worked like a charm.

The primary key is based off of [acct_num] (the account number). [acct_type] is four character text...

andrewd.smith (3/24/2009)

Basically I have a table that subtracts the avg value (for all accounts) from the account's value - creating a 'difference' column. From there, I want to select...

*Bookmarked* Thanks.