USP_DATALIST_EMAILSCHEDULE_EMAILLISTS

Returns a collection of email list IDs associated with a given email table.

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILSCHEDULEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EMAILSCHEDULE_EMAILLISTS(@EMAILSCHEDULEID uniqueidentifier)
                as
                    set nocount on;

                    select EEL.ID as MYID, EL.ID as ID, EL.NAME
                    from dbo.EMAILSCHEDULE_EMAILLIST EEL
                    join dbo.EMAILLIST EL
                    on EL.ID = EEL.EMAILLISTID
                    where EEL.EMAILSCHEDULEID = @EMAILSCHEDULEID