USP_REPORT_PRINTMEMBERSHIPCARDS_OUTPUT

            CREATE procedure dbo.USP_REPORT_PRINTMEMBERSHIPCARDS_OUTPUT
            (
                @ID uniqueidentifier
            )
            with execute as owner
            as
                set nocount on;

                select
                    MC.ID MEMBERSHIPCARDID,
                    dbo.UFN_MEMBERSHIPPROGRAM_GETNAME(MS.MEMBERSHIPPROGRAMID) MEMBERSHIPPROGRAMNAME,
                    dbo.UFN_MEMBERSHIPLEVEL_GETNAME(MS.MEMBERSHIPLEVELID) MEMBERSHIPLEVELNAME,
                    '*' + MC.CARDNUMBER + '*' CARDNUMBER,
                    MS.LOOKUPID as MEMBERSHIPID,
                    C.PICTURE CONSTITUENTPICTURE,
                    MC.NAMEONCARD,
                    (    select top(1) datepart(year, MT.TRANSACTIONDATE)
                        from dbo.MEMBERSHIPTRANSACTION MT
                        where MT.MEMBERSHIPID = MS.ID and MT.ACTIONCODE = 0
                        order by MT.TRANSACTIONDATE asc
                    ) as MEMBERSINCE,
                    MC.EXPIRATIONDATE
                from
                    dbo.MEMBERSHIP MS
                inner join
                    dbo.MEMBER M
                        on MS.ID = M.MEMBERSHIPID
                inner join
                    dbo.MEMBERSHIPCARD MC
                        on M.ID = MC.MEMBERID
                left outer join
                    dbo.CONSTITUENT C with (nolock)
                        on M.CONSTITUENTID = C.ID
                where
                    MC.PRINTMEMBERSHIPCARDSPROCESSSTATUSID = @ID

                return 0;