Avatar of lin111106
lin111106
 asked on

How do I write insert statement in MS SQL from calculations in views

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.
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
frankytee

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
frankytee

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck