V_SIMPLEDATALIST_SIMPLEACKLETTERS

Returns a list of available simple acknowledgement letters

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(100)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:47:55 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_SIMPLEACKLETTERS AS



      select 
            NAME as LABEL
        from 
        dbo.COMMUNICATIONLETTER
      where
        COMMUNICATIONTYPECODE = 3 and 
        ID = (select top 1 SUBC.ID from dbo.COMMUNICATIONLETTER as SUBC where SUBC.NAME = COMMUNICATIONLETTER.NAME) -- Name is not a unique on its own