You are tasked with creating a stored procedure in your lakehouse that processes and aggregates daily sales data. Describe the steps you would take to create this stored procedure, including the use of temporary tables and error handling mechanisms.