V_SIMPLEDATALIST_MEMBERSHIPCARDFORMATSINUSE

Returns a list of membership card formats that are being used by membership programs or the print membership cards process.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(255)

Definition

Copy

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



                select
                    distinct LABEL
                from (
                    select
                        CARDFORMAT LABEL
                    from
                        dbo.MEMBERSHIPPROGRAM

                    union

                    select
                        MEMBERSHIPCARDFORMAT LABEL
                    from
                        dbo.PRINTMEMBERSHIPCARDSPROCESS
                ) CARDFORMATS
                where
                    len(LABEL) > 0