Expressions in "select" and "order by"

[alexerm]

Hi,

Here is sql type of query I'm trying to execute:

SELECT a=3,b=4,c=a+b

However, it does not let me do it, because I'm trying to use variebles "a" and "b" in calculating "c".

Any suggestions, why it does not let me do it?

P.S. In my real query "a" and "b" are calculated using complicated subqueries, so I don't want to repeat those subqueries in calculating "c".

Thanks,

Alex

 

[sunila7]

Hi,

Try this query

Select a,b,a+b c From
(SELECT a=3,b=4) tbl

Sunil

 

[dinzana]

How about this one?

declare @a int
declare @b int
declare @c int

set @a=3
set @b=4

select @c = @a+@b

print @c

 

[JamesLean]

Or you could just do:

SELECT a = 3, b = 4
SELECT c = a + b

;-) --James

 

[tlbroadbent]

Do your complex calculations in a sub-query and then select from the sub-query to perform the final calculation.

SELECT qry.a, qry.b, c = qry.a + qry.b
From
(Select a=<complex formula>, b=<another complex formula>
From yourtable Where <some criteria>) As qry If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[alexerm]

Thanks