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 14, 2010 at 7:23 am

    #1103582

    Your revised T_SQL to adjust the calculated value of MonthsInService appears to do the job properly .. Go ahead and test further.

    Have you considered eliminating the computed columns from the table and do all the calculations in your T-SQL select statement?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]