I have made one SP which sends an email. The email is sent successfully. In the email body i wish to sent an email something like
Dear <Patient FirstName> <Patient LastName>,
Your Appointment for <Checkup> is scheduled at <Date & Time>
Ignore the italic font, all the detail under '< >' comes from another stored procedure.
The SP that contains query to send email is attached as "Email-SP.txt". The Patient Information containing query is attached as "Patient-Info.txt". A sample result set is attached as an image.
My Question: How to bring the patient information (Patient-Info.txt) so that email with above format is sent up?
Let me know for any doubts.