Query to check schedule vs production?

[atd]

We have a large practice and before we close the month I print the schedule and compare providers schedules with the monthly production & income reports. If production shows up on a day a provider wasn't scheduled it's a red flag and I check to see if it should have gone to someone else. With 36 provider schedules to look at, this is very time consuming. Does anyone have a query that could help with this?

[Rickliftig]

36 providers! Yikes - solution - hire an administrative assistant <VBG>!

Actually this is an interesting question - can an Excel spreadsheet be monkeyed around to generate an SQL query and place the result in the cells? That would be a good solution if it is possible.