USP_SIMPLEDATALIST_WEALTHSOURCES_REFRESHABLE

This simple datalist returns all built-in, refreshable wealth sources.

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_WEALTHSOURCES_REFRESHABLE
            as
                set nocount on;
                select 
                    WEALTHSOURCE.[SOURCE] as VALUE,
                    WEALTHSOURCE.[SOURCE] as LABEL
                from
                    dbo.[WEALTHSOURCE]
                where
                    ISBUILTIN = 1 and
                    ISREFRESHABLE = 1;