Thanks for the assist.

What I found to be causing the duplication that I was seeing was using the sp_send_dbmail inside that stored procedure. Another stored procedure runs the stored procedure...