|
December 7th, 2005, 03:34 PM
|
|
Authorized User
|
|
Join Date: Sep 2005
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
quote:Originally posted by jbenson001
Either use:
DecimalValue1 + DecimalValue1*(DecimalVal1*DecimalVal2) as col2
OR
Use a temp table
SELECT ( DecimalValue1 * DecimalValue1 ) AS [COLUMN 1], DecimalValue1, DecimalValue1
into #temp
select [column 1], DecimalValue1 + DecimalValue1 * [column 1] AS [column 2]
From #Temp
|
one more time thanks for all help
|
