USP_DATALIST_FEPSUBMITPROCESSDATA

A datalist which returns all of the data for the fundraising effectiveness project submit process.

Parameters

Parameter	Parameter Type	Mode	Description
@TYPE	tinyint	IN	Type
@PERIOD1STARTDATE	datetime	IN	Period 1 start date
@PERIOD1ENDDATE	datetime	IN	Period 1 end date
@PERIOD2STARTDATE	datetime	IN	Period 2 start date
@PERIOD2ENDDATE	datetime	IN	Period 2 end date
@SITEID	uniqueidentifier	IN	Site

Definition

Copy



create procedure dbo.USP_DATALIST_FEPSUBMITPROCESSDATA
(
    @TYPE tinyint,
    @PERIOD1STARTDATE datetime,
    @PERIOD1ENDDATE datetime,
    @PERIOD2STARTDATE datetime,
    @PERIOD2ENDDATE datetime,
    @SITEID uniqueidentifier
)
as
    set nocount on;

    select 
        SEQUENCE,
        CATEGORY,
        PERIOD1NUMDONORS,
        PERIOD1AMOUNT,
        PERIOD2NUMDONORS,
        PERIOD2AMOUNT,
        GAINSLOSSES,
        GAINSLOSSESPERCENT
    from dbo.UFN_FEPSUBMITPROCESS_GETDATA(@TYPE, @PERIOD1STARTDATE, @PERIOD1ENDDATE, @PERIOD2STARTDATE, @PERIOD2ENDDATE, @SITEID)
    order by SEQUENCE;