fnCountTargetAddresses

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@EmailListID	int	IN
@AppealID	int	IN
@ListOrigin	tinyint	IN

Definition

Copy



        CREATE FUNCTION [dbo].[fnCountTargetAddresses](@EmailListID INT, @AppealID INT, @ListOrigin tinyint)
        RETURNS INT AS 
        BEGIN
            DECLARE @Count INT

            IF @ListOrigin = 1
                BEGIN
                    SELECT @COUNT = Count([ID]) FROM fnGetTargetXListAddresses(@EmailListID,@AppealID) 
                END
            IF @ListOrigin = 2
                BEGIN
                    SELECT @COUNT = Count([ID]) FROM fnGetTargetQueryAddresses(@EmailListID,@AppealID) 
                END

            RETURN @Count
        END