you can do in both ways
either
CASE VERY LONG FORMULA < 100 Then something as Result2
or make first result into derved table and then use it like
SELECT ....,
CASE Result1 < 100 Then something as Results2,
..
FROM
(
SELECT ...,
VERY LONG FORMULA as Results1
FROM
....
)t
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Use results from one column for another column
Posted - 01/04/2013 : 18:00:50
