create view

Hot Topic

OUTER JOIN table limit?
Problem with SSIS Transaction...Transaction Scope
send mail task
Management Studio Still will not install
Cannot connect to Database in Server Management Studio
rsExecutionNotFound
Failed to generate a user instance of SQL Server
Deny access to a view
Several Databases, several servers
array with sql server 2000

SQL Server

An internal error occurred on the report server. See the error log for more details.
Updating Table Structures
Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
Reuse of Recursive Queries
is there documenation on format of transaction log entries
Is there Simple way to get all dimension & Hierarchy levels from a database?
How to force the page footer to display at the *bottom* of the page
SQL Server Backups - Help please
specified sort order in matrix column
Update conflict

create view

CREATE VIEW getUsedColumns AS SELECT * FROM (SELECT DISTINCT attr FROM iba UNION SELECT DISTINCT attr FROM new_iba) WHERE attr != 0;

its working with oracle

how to chenge in t-sql

thanx

Answer this question

create view

  • Al Sauve

    You need to specify an alias for the derived table. And you don't really need the DISTINCT in each of the SELECT statements since the UNION will eliminate the duplicates anyway. You will get better performance by writing it as:
    SELECT * FROM (SELECT Dattr FROM iba UNION SELECT attr FROM new_iba) as t
    WHERE attr != 0;


  • Ninja_Programmer

    Hi,

    you have to ALIAS Your SubQuery.

    CREATE VIEW getUsedColumns
    AS
    SELECT * FROM
    (
    SELECT DISTINCT attr
    FROM iba
    UNION
    SELECT DISTINCT attr
    FROM new_iba
    ) SomeSubQuery
    WHERE attr != 0;

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • create view
Answer this question