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:
Room_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
