Creating stored procedure in sql
I need help with following questions:
Design the stored procedure to answer the following question: What is the utilization of the room for a one week period. The procedure will return a list of the rooms showing how many of each service (procedure or consultation) with the total time used for each plus a grand total for the room starting at the specified search_start_date for 7 days.
Be sure to handle errors gracefully. Errors may include invalid room or date range.
Specification for the stored procedure:
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowRoom_utilization (search_start_date)
Submit the solution that you have designed and discuss its merits as part of the submission. This means that there will be two files, the sql code and a document discussing it.
I will attach the sql file
Thank you
