I need to create one row of data for my emailing program.
I have one table for Employee Information including Functional Mgr
Another Table has Employee Assets and each Asset has an assigned asset manager.
In my Email program, I needt to create one Row that Includes Functional Mgr Email & Name, Talent Mgr Email and Name and the Asset Manager Email and Name.
I don't have to worry about the assets. I have created a query within an HTML body that returns a table with those values.
I do need to include all Asset Managers, the one Functional Manager and the one Talent Manager in the email.
I'm thinking that I can create a temp table to pull the emal addresses from in my stored procedure.