USP_GET_DATASOURCEID_BYMERGEID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TRID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_GET_DATASOURCEID_BYMERGEID
@TRID uniqueidentifier
as
begin
select top 1
DATASOURCEID from dbo.EMAILTEMPLATE ET inner join dbo.EMAIL EM on ET.ID=EM.EmailTemplateID where EM.ID =(SELECT top 1 EMAILID from dbo.EMAILJOB_RECIPIENT where MERGEID = @TRID)
end