SQL Server Performance

Views

Discussion in 'Getting Started' started by doyle, Mar 17, 2009.

  1. doyle New Member

    This may seem like a very stupid question to some..but I'm new to SQL!
    I need to assign avg(ExpValue) a name as i am getting the following error:
    Msg 4511, Level 16, State 1, Procedure ExpenseItem_View1, Line 2 Create View or Function failed because no column name was specified for column 2 .....how do i do this?!
    CREATE VIEW View_View1 AS
    SELECT ExpType, avg(ExpValue)
    FROM Expenses
    GROUP BY ExpType
  2. FrankKalis Moderator

    CREATE VIEW View_View1 AS
    SELECT ExpType, avg(ExpValue) AS SomeFancyName
    FROM Expenses
    GROUP BY ExpType
    should work

Share This Page