Using computed Columns to Create another Computed Column in a table

• deepakkn

  Default port

  Points: 1430

  More actions

  November 9, 2009 at 10:15 pm

  #135235

  Hi,

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

  Like

  Column A = B+C

  We can use this like E = (B+C)+D.

  But can we use it like this?

  Column E = A+D

  Thanks

  Deeps

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  November 10, 2009 at 4:22 am

  #1077150

  Like

  Column A = B+C

  We can use this like E = (B+C)+D.

  But can we use it like this?

  Column E = A+D

  If you want to do it apply the same logic implemented to calculate column 'A' (in your example) and then add the same with 'D' to derive 'E'

  something like E=B+C+D

  You cannot implement the computed column directly here to calculate E.

  Thanks,

  Chandru