Hi folks,

Could somebody guide me with example how can i add the values of two computed columns to make a third computed column?

I am using SQL Server 2005 dev. edition.

Thanks & Regards,
Zain.

You wish to populate an existing column in a table or create a new column in an extract? Makes a difference if we knew the intended purpose and ddl or dml expectations.

You cannot make a 3rd Computed Column with the results of two existing computed columns.

BOL Says "The expression can be a noncomputed column name, constant, function, variable"

I think you'll have to recalculate/concatenate your two columns formula to make up your third

((formula1) + (formula2)) in 3rd Computed Column