USP_SIMPLEDATALIST_FINANCIALINSTITUTIONBRANCHNAMES

This simple datalist returns all distinct constituent financial institution branch names.

Definition



CREATE procedure dbo.[USP_SIMPLEDATALIST_FINANCIALINSTITUTIONBRANCHNAMES]
as
  set nocount on;

  select distinct
    [ID] as [VALUE],
    [BRANCHNAME] as [LABEL]
  from dbo.[FINANCIALINSTITUTION]
  where [BRANCHNAME] <> '';

  return 0;