Home Forums SQL Server 2008 T-SQL (SS2K8) Using Results from one column to calculate another column RE: Using Results from one column to calculate another column

  • January 4, 2013 at 10:21 pm

    #1574018

    I already have Results1 and it's silly to do it again just to calculate Results2.

    I am assuming that Results1 is a data set that you are selecting a table.

    I agree with Joe on this one. You can user a CTE or a derived table to calcualte Results2 on the basis of Results1.

    Here are a few links on how to use them:

    Using Derived Tables[/url]

    Using CTE

    Hope this helps.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉