USP_REPORT_PRINTMEMBERSHIPCARDSNOPICTURE_OUTPUT

Returns membership card data that can be used by membership card reports.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_REPORT_PRINTMEMBERSHIPCARDSNOPICTURE_OUTPUT
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select
                    MEMBERSHIPCARD.ID MEMBERSHIPCARDID,
                    dbo.UFN_MEMBERSHIPPROGRAM_GETNAME(MEMBERSHIP.MEMBERSHIPPROGRAMID) MEMBERSHIPPROGRAMNAME,
                    dbo.UFN_MEMBERSHIPLEVEL_GETNAME(MEMBERSHIP.MEMBERSHIPLEVELID) MEMBERSHIPLEVELNAME,
                    '*' + MEMBERSHIPCARD.CARDNUMBER + '*' CARDNUMBER,
                    MEMBERSHIP.LOOKUPID as MEMBERSHIPLOOKUPID,
                    MEMBERSHIPCARD.NAMEONCARD,
                    (
                        select datepart(year, min(MEMBERSHIPTRANSACTION.TRANSACTIONDATE))
                        from dbo.MEMBERSHIPTRANSACTION
                        where MEMBERSHIPTRANSACTION.MEMBERSHIPID = MEMBERSHIP.ID and MEMBERSHIPTRANSACTION.ACTIONCODE = 0
                    ) as MEMBERSINCE,
                    MEMBERSHIPCARD.EXPIRATIONDATE
                from
                    dbo.MEMBERSHIPCARD
                inner join
                    dbo.MEMBER on MEMBERSHIPCARD.MEMBERID = MEMBER.ID
                inner join
                    dbo.MEMBERSHIP  on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID
                where
                    MEMBERSHIPCARD.PRINTMEMBERSHIPCARDSPROCESSSTATUSID = @ID;

                return 0;