Home Forums SQL Server 2005 Development is there away of using a computed column in another computed column formular in sql server 2005 RE: is there away of using a computed column in another computed column formular in sql server 2005

  • January 12, 2010 at 12:11 pm

    #1102660

    You can place the original calculation for MonthsInService into the calculation for MyCol3. It would look like this:

    datediff(year,[DateEngaged],getdate()) * 2

    Hope this helps,

    Eli