0

I created a query with a lot of calculations and cannot figure out how to store a calculated value to a variable without including in within the SELECT statement. Example:

SELECT (VAL_1 + VAL_2) as CALC_1, (CALC_1 + VAL_3) as CALC_2 FROM MY_TABLE

I can use CALC_1 alias in additional SELECT's. How do I use alias if i did NOT want to display/SELECT it? The below gave me an Invalid Query Error.

DECLARE @CALC_1 INTEGER
SET @CALC_1 = VAL_1 + VAL_2
SELECT @CALC_1, @CALC_1 + VAL_3
FROM MY_TABLE
Dan Grossnickle
  • 45
  • 1
  • 7

1 Answers1

0

If I understand correctly you need to nest it in a Derived Table:

SELECT (CALC_1 + VAL_3) as CALC_2 
FROM 
 (
   SELECT (VAL_1 + VAL_2) as CALC_1 
   FROM MY_TABLE
 ) as dt
dnoeth
  • 59,503
  • 4
  • 39
  • 56