MS SQL DB purpose to track custom order work. I have a table that allows entry for the number of procedures it takes for each order. From that I created a view that joins to tables to calculate total number of processes it takes based on type of work. Then I have to calculate the number of minutes it takes to complete the order. I know that 17 process can be completed in 1 hour/60 minutes so that each process takes 3.5 minutes to complete. From that I know that with 4 employess I can completed 1800 process in a 7.5 hour day. I know that calcs and can retrieve them in views, but don't know how to write them back to the table.
I have basic skills and don't know how to write calculations In MS SQL 2000 Db. If I can learn how to write back the calculations from query then fine, if not I need to know how to write calculation for the table. Thank you.
How should I do this? I am happy to attach print screen of my DB views and table diagram if needed.