USP_BBNC_GETEMAILDATAFROMBBEC

Retrieves data about a specific email if it was pushed down to us from Blackbaud Internet Solutions.

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILID	int	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_GETEMAILDATAFROMBBEC
            (
                @EMAILID int
            )
            as 
            set nocount on;

            select top 1
                EMAILNAME,
                EMAILSUBJECT
            from dbo.NETCOMMUNITYEMAILJOBRECIPIENT
            where EMAILBBNCMAPID = @EMAILID;