Post reply

Update a column

  • April 14, 2009 at 5:09 pm

    #131276

    I have a table with a column of data for a period of three months. The data in the column are lower by a factor of 18% due to a wrong multiplier being supplied.

    That being the case, is there an easy method to correct the single column containing the three months of incorrect data?

    Thanks

    Mitch

  • April 14, 2009 at 8:50 pm

    #977813

    Probably - but not without a lot more information. Please review the article I link to in my signature. This article will show you how to post your question to get a better answer.

    Without the table structures, sample data and expected output - the only thing anyone can say for certain is that you are going to need to use an update statement to update the data in the column.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • April 14, 2009 at 9:13 pm

    #977816

    mmitchmcp (4/14/2009)

    I have a table with a column of data for a period of three months. The data in the column are lower by a factor of 18% due to a wrong multiplier being supplied.

    That being the case, is there an easy method to correct the single column containing the three months of incorrect data?

    Thanks

    Mitch

    Making a huge assumption here (and I know where that can lead), but if every single row of data in that single column is off by 18%, then what prevents you from using an UPDATE statement?

    UPDATE TableA

    set Column1 = Column1 * 1.18

    This will increase every single row in that column by 18%. So if the data was 100 prior to the update, it would now be 118.

    Fraggle

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply