USP_DATALIST_MEMBERSHIPCARDFORMATSINUSE

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

Copy


                CREATE proc dbo.USP_DATALIST_MEMBERSHIPCARDFORMATSINUSE
                as
                    set nocount on;

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

                        union

                        select
                            MEMBERSHIPCARDFORMAT VALUE
                        from
                            dbo.PRINTMEMBERSHIPCARDSPROCESS

                        union

                        select
                            NAME VALUE
                        from dbo.LETTERTEMPLATE
                        where LETTERTEMPLATETYPECODE = 8
                            and ID in (select LETTERTEMPLATEID from dbo.MEMBERSHIPPROGRAM)
                    ) CARDFORMATS
                    where
                        len(VALUE) > 0
                    order by
                        VALUE;

                    return 0;