I am working on a project that is a scheduling system. I have a table with each record being a time slot 12:00, 12:15, 12:30, 12:45.....etc. I have another table that is generated based off code that determines the flow of a product and gives the time that may or maynot be at a specific time slot for scheduling for example lets say 12:06. I want to find the closest time slot. So for 12:06 it should bring back 12:00. How do I accomplish this with a stored procedure?