Home Forums SQL Server 2008 T-SQL (SS2K8) CTE with Linked Server: Mulitpart Identifier could not be bound RE: CTE with Linked Server: Mulitpart Identifier could not be bound

  • July 21, 2014 at 10:41 am

    #1731086

    I don't think it will help at all to know the linked server that is referenced.

    The OP should try a

    SELECT TOP 1 AUFNR FROM afpo

    SELECT TOP 1 AUFNR FROM afko

    SELECT TOP 1 AUFNR FROM s022

    to verify which one fails.

    Then use SELECT * FROM the_table_in_question

    Finally, take a Baseball bat and practice at the "Submit-And-Pray"-Dptmt....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]