spGetEmailList_Subscription_OptOut
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailListID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailList_Subscription_OptOut]
(@EmailListID int )
AS
SELECT
s.UserID,
s.BackOfficeSystemPeopleID,
s.EmailAddress,
dbo.fnGetSystemIDFromPeopleID(s.BackOfficeSystemPeopleID) BackOfficeSystemID,
dbo.fnGetRecordIDFromPeopleID(s.BackOfficeSystemPeopleID) BackOfficeRecordID
FROM [dbo].EmailList_Subscription as s
LEFT OUTER JOIN ClientUsers u on u.id = s.UserID
WHERE s.EmailListID = @EmailListID
AND s.[HasOpted]=0
AND isnull(u.deleted,0) = 0