Home Forums SQL Server 2005 T-SQL (SS2K5) using select union all using multiple databases RE: using select union all using multiple databases

  • August 11, 2014 at 10:43 am

    #1736941

    You can't create views across database using the syntax you're thinking of.

    Instead you could create a view on each database and use that in your view:

    create view view1 as

    use

    select * from db1.schema1.view1

    union all

    select * from db2.schema1.view1

    union all

    select * from db3.schema1.view1

    union all

    select * from db4.schema1.view1

    Make sure you vae permissions to select from those views and matching columns.


    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]