Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: Use of Delcare

    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...

  • RE: Using multiple servers in a query

    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...

  • RE: Using multiple servers in a query

    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...

  • RE: Using multiple servers in a query

    😀 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.

  • RE: Using multiple servers in a query

    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...

  • RE: Using multiple servers in a query

    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.

  • RE: Using multiple servers in a query

    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...

  • RE: Using multiple servers in a query

    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...

  • RE: Using multiple servers in a query

    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)?

  • RE: SELECT DISTINCT TOP 1

    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...

  • RE: SELECT DISTINCT TOP 1

    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...

  • RE: MEAN()

    Thanks! Worked like a charm.

  • RE: MEAN()

    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...

  • RE: MEAN()

    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...

  • RE: COUNT Question

    *Bookmarked* Thanks.

Viewing 15 posts - 1 through 15 (of 21 total)