i have sql that makes the below result set. see the excel file.
now i have this result set emailed to the entire team... i need to make it smarter so that each office (office_id field) gets only their parts of the data set and not others.
how can i splice this dataset into seperate parts based on office?
with it broken up i can then email each batch of records with matching office_id fields to the correlated email for that office (dropoff_email_recip)