USP_SIMPLEDATALIST_WEALTHSOURCESWITHID

This simple datalist returns wealth sources matching specified criteria.

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_WEALTHSOURCESWITHID
                as
                set nocount on;
                select 
                    WEALTHSOURCE.[ID] as VALUE,
                    WEALTHSOURCE.[SOURCE] as LABEL
                from
                    dbo.[WEALTHSOURCE]
                order by
                    WEALTHSOURCE.[ISBUILTIN] desc,
                    WEALTHSOURCE.[SEQUENCE] asc,
                    WEALTHSOURCE.[SOURCE] asc;