Create a Microsoft SQL Server stored procedure to query data

I am working on improving a rather old system I wrote which is still up and running like a charm since 2007. I am rewriting it and bumped into an issue. Here is the situation. It is about an agenda where appointments are stored and must be retrieved to be displayed to the end user. Two tables are involved: the doctors' table and the agenda table. The doctor's table contains for each date an hour from/to for morning and afternoon, and for each day of the week. See attached pictures [login to view URL] where I am highlighting values for a Monday. As you can see below the structure TimeFrom/To repeats itself for each day morning and afternoon. The agenda table is pretty simple, see [login to view URL], the doctor, the day and hour. I know those fields could be in one but that is the way it is and no change of the database's structure will be considered. How it is working now. Currently, the system queries the database for each day and each period (morning and afternoon). I don't need you to write any code on the server but I attached a print screen of the code as information, where you can see that depending on the day of the week a SQL Statement is written and this goes for a range of dates. And it works. But that means for a week, or 7 days, 14 calls are made to the database and as I am thinking of getting more users that might be an issue later on. That is what I want to optimize. But instead of querying the database for each date and period what I want is to create one stored procedure and make one call. You can see the results in the print screen [login to view URL] I am getting and expecting. The trick is that the where statement on the hour will depend on the weekday of the underlying date, for example, if the day is a Monday it must consider Me_TimeFromMoAM, Me_TimeToMoAM,Me_TimeFromMoPM and Me_TimeToMoPM; and for a Tuesday Me_TimeFromTuAM, Me_TimeToTuAM,Me_TimeFromTuPM and Me_TimeToTuPM, etc. What I will provide: a sample database with data What I am expecting: a stored procedure with as a parameter the doctor's id, a date range from/to that will send back the information I need. The test will be easy, I will try it passing 9 as and id date from: 30/1/2023 and date to: 05/2/2023 and the result should be the same as running the 14 queries generated from my code, that query will be included with the information. If you want your bid to be considered please copy/paste the following sentence at the beginning of your bid: "I have got experience in writing stored procedure running on Microsoft SQL Server" Thank you for reading, Jean-Luc