Create a Dynamic Link in a Message Body

Create a dynamic link in a message body.

Procedure

1. Navigate to the Cora SeQuence database.
2. Create the following stored procedure.
   CREATE PROCEDURE sp_{StoredProcedureName} AS SELECT '<a href="{link}" target="_blank">{TEXT}/<a'> AS link
3. In the message body, insert the following expression.
   Link to {SQL: exec sp_StoredProcedureName}