V_SIMPLEDATALIST_BANKINGSYSTEMUNIVERSALNAME

Fields

Field Field Type Null Description
LABEL nvarchar(50)

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:44:21 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_BANKINGSYSTEMUNIVERSALNAME AS



                select
                    BANKINGSYSTEM.NAME as LABEL
                from
                    dbo.BANKINGSYSTEM
                    left join dbo.CONDITIONSETTING on BANKINGSYSTEM.CONDITIONSETTINGNAME = CONDITIONSETTING.NAME
                where
                    CONDITIONSETTING.ID is not null;