USP_APPEALMAILING_GETCACHEDINFO

Retrieves count data that was cached by the Marketing Effort Segment Record Count Calculation process.

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALMAILINGID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_APPEALMAILING_GETCACHEDINFO
(
    @APPEALMAILINGID uniqueidentifier
)
as
begin

    declare @RECORDCOUNTDATECACHED date;

    select top 1
        @RECORDCOUNTDATECACHED = MKTSEGMENTATIONSEGMENTCACHEINFO.RECORDCOUNTDATECACHED
    from
        MKTSEGMENTATIONSEGMENT
    inner join
        MKTSEGMENTATIONSEGMENTCACHEINFO on MKTSEGMENTATIONSEGMENTCACHEINFO.SEGMENTID = MKTSEGMENTATIONSEGMENT.ID
    where
        MKTSEGMENTATIONSEGMENT.SEGMENTATIONID = @APPEALMAILINGID;

    select
        sum(MKTSEGMENTATIONSEGMENTCACHEINFO.RECORDCOUNT) [RECORDCOUNT],
        @RECORDCOUNTDATECACHED [RECORDCOUNTDATECACHED]
    from
        MKTSEGMENTATIONSEGMENT
    inner join
        MKTSEGMENTATIONSEGMENTCACHEINFO on MKTSEGMENTATIONSEGMENTCACHEINFO.SEGMENTID = MKTSEGMENTATIONSEGMENT.ID
    where
        MKTSEGMENTATIONSEGMENT.SEGMENTATIONID = @APPEALMAILINGID
    group by
        MKTSEGMENTATIONSEGMENT.SEGMENTATIONID;

end