USP_SIMPLEDATALIST_BANKACCOUNT_BANK
This simple list returns a list of all banks.
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_BANKACCOUNT_BANK as
set nocount on;
select
BANK.ID as VALUE,
CONSTITUENT.NAME as LABEL
from dbo.BANK
join dbo.CONSTITUENT on BANK.ID = CONSTITUENT.ID
order by CONSTITUENT.NAME