USP_DATAFORMTEMPLATE_EDITLOAD_GIVINGLISTSUMMARYSETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GIVINGLISTSUMMARYSETTINGS
(
    @CURRENTAPPUSERID uniqueidentifier = null,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SUMMARYSETTINGS xml = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 1
    set @TSLONG = 0

    select top 1
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @SUMMARYSETTINGS = SUMMARYSETTINGS
    from dbo.GIVINGLISTSUMMARYSETTINGS
    where APPUSERID = @CURRENTAPPUSERID

if @SUMMARYSETTINGS is null
begin
    set @SUMMARYSETTINGS = 
        '<SUMMARYSETTINGS>
            <ITEM><ID>CAMPAIGN</ID><NAME>Campaign</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>ALL</DISPLAY></ITEM>
            <ITEM><ID>APPEAL</ID><NAME>Appeal</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>ALL</DISPLAY></ITEM>
            <ITEM><ID>DESIGNATION</ID><NAME>Designation</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>ALL</DISPLAY></ITEM>
            <ITEM><ID>MONTH</ID><NAME>Month</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>CITY</ID><NAME>City</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>STATE</ID><NAME>State</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>POSTALCODE</ID><NAME>Postal code</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>TRANSACTIONTYPE</ID><NAME>Transaction type</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>DONOR</ID><NAME>Most Generous donor</NAME><AMOUNTRAISED>True</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>TOPPERFORMER</DISPLAY></ITEM>
            <ITEM><ID>UNIQUEDONOR</ID><NAME>Unique donors</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>True</COUNT><DISPLAY>NUMBEROF</DISPLAY></ITEM>
            <ITEM><ID>FIRSTTIMEDONOR</ID><NAME>First time donations</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>True</COUNT><DISPLAY>NUMBEROF</DISPLAY></ITEM>
            <ITEM><ID>REPEATDONOR</ID><NAME>Repeat donors</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>True</COUNT><DISPLAY>NUMBEROF</DISPLAY></ITEM>
            <ITEM><ID>AVERAGEGIFTCOUNTPERDONOR</ID><NAME>Average gift count</NAME><AMOUNTRAISED>False</AMOUNTRAISED><AMOUNTRECEIVED>False</AMOUNTRECEIVED><COUNT>False</COUNT><DISPLAY>NUMBEROF</DISPLAY></ITEM>
        </SUMMARYSETTINGS>'
end
return 0;