spGetEmailProjectAppeal_EmailLists
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailProjectAppealID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailProjectAppeal_EmailLists]
@EmailProjectAppealID int
as
SELECT el.[ID] "EmailListID"
,el.[ClientsID]
,el.[OwnerID]
,el.[Name]
,el.[Description]
,el.[type]
,el.[DataSourceID]
,epal.[AppealListType]
,epal.[EmailProjectAppealID]
,epal.[ID] "AppealEmailListID"
FROM [dbo].[EmailProjectAppeal_EmailList] epal inner join [dbo].[EmailList] el on epal.EmailListID = el.[ID]
WHERE epal.[EmailProjectAppealID] = @EmailProjectAppealID
AND epal.Deleted = 0