ASP & SQL Server 2008 : calculated value from another calculated value

Question

I need to use a SQL statement that is bound to a Gridview & needs to be something like

SELECT * from Table Sum(Column1) AS S00, (S00/CONSTANT) AS C01 or

SELECT * from Table Sum(Column1) AS S00, Sum(Column1) / CONSTANT AS C01

CONSTANT will be a value passed to the query as a session variable.

i.e the 2nd column of the Gridview is calculated from the result of 1st calculation.

What will be the best way to achieve this?

It's to calculate or calculation and calculated value .... — marc_s
– marc_s, Commented Sep 1, 2011 at 20:59

Aaron Bertrand · Accepted Answer · 2011-09-01 21:00:14Z

1

You'll need to repeat the expression, or use a subquery e.g.

SELECT *, C01 = (S00/Constant) 
FROM
(
 SELECT S00 = SUM(Column1)
  FROM table
) AS x;

answered Sep 1, 2011 at 21:00

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1