V_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERBYID

Returns a list of charity claim reference numbers with the VALUE column set to the row ID.

Fields

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

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:41:04 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERBYID AS



                select 
                    ID as VALUE,
                    case when CHARITYCLAIMREFERENCENUMBER.DESCRIPTION = '' then CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                         else CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER + coalesce(' - ' + min(CHARITYCLAIMREFERENCENUMBER.DESCRIPTION),'')
                    end as LABEL
                from 
                    dbo.CHARITYCLAIMREFERENCENUMBER
                group by CHARITYCLAIMREFERENCENUMBER.ID,CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,CHARITYCLAIMREFERENCENUMBER.DESCRIPTION;