V_SIMPLEDATALIST_BANKACCOUNT_BANK

This simple list returns a list of all banks.

Fields

Field	Field Type	Null	Description
VALUE	uniqueidentifier
LABEL	nvarchar(154)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:13:49 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_BANKACCOUNT_BANK AS



                select distinct
                    BANK.ID as VALUE, 
                    CONSTITUENT.NAME as LABEL
                from dbo.BANK
                    join dbo.CONSTITUENT on BANK.ID = CONSTITUENT.ID