Thank you!! That actually worked.

This is how the two columns come out as in excel when I open the csv attachment in the email. It should rather come out in two different columns and...

Ok I replaced the table variable with the table name and getting following errors now. Can I not reference variable @EMP_ID and @intFlag in the query? Is that not allowed?...

Thank you for all the assistance. I am able to get the function to run but when I do the following in a T-SQL block, I am getting an error:

DECLARE...