As SPs borned to run simultaneously you have to be creative here...
Think of something like this:
1. Check if there is a temp table by name of today date
2. No - create one and run the rest of the SP to push data into, then select data from the table
3. Yes - select data from the table