I have a situation that I do not know how to handle at the moment. I am new to SQL Server 2005 so please forgive me.
What I am trying to do is make 2 columns in one table equal to another column that is located in the same table. Here is what I must do.
deduc_no_of_deduc * deduc_amt_per_deduc
The data from this calculation needs to go in:
deduc_annual_amt
How do I do this effectively? Everything I have tried has not worked right.
