USP_GET_EMAILLIST_BYEMAILID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_GET_EMAILLIST_BYEMAILID
@EMAILID int
as
begin
Select EL.ID, EL.Name,EL.Description, EL.AcquiredStatus,EL.AcquiredDate,EL.AcquiredStartDate,EL.AcquiredRecordCount,EL.DataSourceID from dbo.Email E
inner join dbo.Email_EmailList EEL on EEL.EmailID= E.ID
Inner join dbo.EmailList EL on EL.ID = EEL.EmailListID where E.id =@EMAILID and EEL.IsTest = 0;
end