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;