Post reply

SQL Pass Through Query

  • July 8, 2009 at 2:17 pm

    #206682

    I'm trying to convert a SQL pass through query in access 07 into SQL Server 05. The pass through query comes from a data warehouse, and I want to create the same query in SQL Server 05 and run everything from one location (pull records from data warehouse, delete, create tables, make backup tables, etc. Thanks to the input I've received I have converted delete, update, and make table queries. I'm running into an additional problem with the data warehouse address it is at the end of one of the pass through queries like this:

    from "RWGT2200"."MILDAND"."LMHARTVW02" T1

    of course I get this error:

    Msg 208, Level 16, State 1, Line 1

    Invalid object name "RWGT2200"."MILDAND"."LMHARTVW02" T1'

  • July 8, 2009 at 3:30 pm

    #1021981

    duplicate post.

    Discussion already started here.


    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]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply