Returning Complicated Computed Column from a SP

• Bryan P. Clauss

  SSC Eights!

  Points: 959

  More actions

  January 19, 2006 at 2:58 pm

  #90449

  I need to return a computed column from a stored procedure, and I will need to use this computation in other places in the same Select statement.

  A simple example might be:

  Select (Length * Width) AS 'Area',
         (Area * Height) AS 'Volume'
  From   Stuff
  Where  Area > 25

  In this case, I want to replace "Area" with the (Length * Width) formula, and use it multiple times. 

  Thank you,

    Bryan

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  January 19, 2006 at 3:56 pm

  #615952

  You are better off using a function. Read up on 'create function' in BOL.

• Jesper-244176

  SSCertifiable

  Points: 7142

  More actions

  January 20, 2006 at 2:46 am

  #616000

  Or you could use a derived table:

  Select Area, (Area * Height) as 'Volume'

  from

  (

    select Height, (Length * Width) AS 'Area' From Stuff

  )

  as AreaStuff

  where Area > 25