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:40 am

    #1103597

    bitbucket-25253 (1/14/2010)

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

    I haven't. are there any know serious drawbacks that i should be watching for when using computed columns?. i have to admit this is the first time i want to use computed columns in production and am not sure if its a good idea or not. am therefore more than ready to listen to and evaluate any advices.