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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy