Viewing 15 posts - 1 through 15 (of 21 total)
Mayank Khatri (5/27/2009)
DECLARE @symbol table (id int, alpha varchar(5))
INSERT INTO @symbol
SELECT 1,'ABK' UNION
SELECT 2,'UYG' UNION
SELECT 3,'AIG' UNION
SELECT 4,'SKF'
select * from @symbol ;
U do have to use table variables, and then...
May 27, 2009 at 7:45 am
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...
April 24, 2009 at 12:26 pm
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...
April 23, 2009 at 11:51 am
😀 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.
April 22, 2009 at 2:57 pm
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...
April 22, 2009 at 2:41 pm
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.
April 22, 2009 at 2:20 pm
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...
April 22, 2009 at 2:10 pm
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...
April 22, 2009 at 1:49 pm
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)?
April 22, 2009 at 12:26 pm
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...
March 27, 2009 at 3:19 pm
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...
March 27, 2009 at 11:59 am
andrewd.smith (3/24/2009)
What is the table structure?On which column(s) is the table's primary key based?
The primary key is based off of [acct_num] (the account number). [acct_type] is four character text...
March 24, 2009 at 8:06 am
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...
March 24, 2009 at 7:07 am
Viewing 15 posts - 1 through 15 (of 21 total)