I have a number of services that call SQL stored procedures and map their result sets to Record Map Batch objects. The stored procedures take optional start and end date parameters, but default to the prior day for their daily run.
Because the database they're running against is an asynchronously updated data repository for an EHR, there are times where the stored procedures will not capture all the data that should have been there and we need to re-execute the stored proc with a specific date (and sometimes time) range.



