Using computed Columns to Create another Computed Column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Using computed Columns to Create another...

Using computed Columns to Create another Computed Column

Rate Topic

Display Mode

Topic Options

Author

Message

deepakkn

Posted Monday, November 09, 2009 10:12 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 27, 2010 2:33 AM
Points: 186, Visits: 238

Hi,

Can we used the Computed Columns to create another computed Column?

Like
Column A = B+C
Column E = A+D
We can use this like E = (B+C)+D?
But we do we have any other option for this?

Thanks
Deeps

Post #816306

Elliott Whitlow

Posted Monday, November 16, 2009 10:55 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

Hm.. Never tried that.. I bet it wouldn't be difficult to test..

CEWII

Post #819819

SwePeso

Posted Tuesday, November 17, 2009 1:56 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:26 PM
Points: 2,359, Visits: 3,292

No, you can't use a computed column as source for another computed column

The main reason I think is circular reference, like this:

A = B
B = A

N 56°04'39.16"
E 12°55'05.25"

Post #819882

Elliott Whitlow

Posted Tuesday, November 17, 2009 8:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

I figured you couldn't but it was simple enough to test yourself..

CEWII

Post #820092

« Prev Topic | Next Topic »

Permissions