USP_EMAILLIST_GETPROCESSOR
Returns the name of the email list processor to be used for a specified email list.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILLISTS | xml | IN |
Definition
Copy
CREATE procedure dbo.USP_EMAILLIST_GETPROCESSOR
(
@EMAILLISTS xml
)
as
begin
declare @EMAILLISTIDS table (ID int)
insert into @EMAILLISTIDS
select Ints.i.value('.', 'int')
from @EMAILLISTS.nodes('ArrayOfInt/int') Ints(i)
select EL.ID, ISNULL(DS.LISTPROCESSOR, '')
from @EMAILLISTIDS ELIDS
inner join dbo.EMAILLIST EL on EL.ID = ELIDS.ID
inner join dbo.DATASOURCES DS on DS.DATASOURCEID = EL.DataSourceID Order by EL.Origin
end