Selected Expressions???

[hussux]

HELP!!! I need to calculate two fields together in a SP bearing in mind that the formula's could get v.big!


Simple Example of the problem...

CREATE PROCEDURE myproc AS
SELECT
f1,
f2,
f1+f2 as f3,
f3+f1 as f4
FROM t1
GO

I need to add together f3 and f1 to equate f4

Please Help!

 

[MalcolmW]

What is f3? You have it defined both as a column of t1, and as an expression f1+f2. Malcolm

 

[carp]

I think you are going to have to go the long way around on this one:

SELECT f1, f2, f1 + f2 as f3, 2*f1 + f2 f4 FROM t1;