USP_SIMPLEDATALIST_WEALTHSOURCES

This simple datalist returns wealth sources matching specified criteria.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEBUILTIN	bit	IN
@INCLUDECUSTOM	bit	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_WEALTHSOURCES(
                    @INCLUDEBUILTIN bit = 0,
                    @INCLUDECUSTOM bit = 1
                )as
                set nocount on;
                select 
                    WEALTHSOURCE.[SOURCE] as VALUE,
                    WEALTHSOURCE.[SOURCE] as LABEL
                from
                    dbo.[WEALTHSOURCE]
                where
                    ((@INCLUDEBUILTIN = 1 and WEALTHSOURCE.[ISBUILTIN] = 1) or
                    (@INCLUDECUSTOM = 1 and WEALTHSOURCE.[ISBUILTIN] = 0)) and
                    WEALTHSOURCE.[SOURCE] <> 'Federal Election Commission'
                order by
                    WEALTHSOURCE.[ISBUILTIN] desc,
                    WEALTHSOURCE.[SEQUENCE] asc,
                    WEALTHSOURCE.[SOURCE] asc;