USP_SIMPLEDATALIST_BANKACCOUNT

This simple list returns a list of open bank accounts.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_BANKACCOUNT as
                    set nocount on;
                    select 
                        BANKACCOUNT.ID as VALUE, 
                        BANKACCOUNT.[ACCOUNTNAME] as LABEL
                    from dbo.BANKACCOUNT
          where STATUSCODE <> 0
                    order by BANKACCOUNT.[ACCOUNTNAME]