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