try the following...
CREATE PROCEDURE GetMyData @Day int
AS
SELECT @Day FROM DoctorsAvailability
GO
You need to pass 4 for Monday 5 for tuesday etc....
I am not sure of this logic, and i am unable to test it as i don't have sql server here...
Regards
Sebastian