USP_MAILPREFERENCE_DELETEBYGROUPCONTACT

Delete all the mail preferences that send to the given constituent as a group contact.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            create procedure USP_MAILPREFERENCE_DELETEBYGROUPCONTACT
            (
                @CONSTITUENTID uniqueidentifier
            )
            as
                delete MAILPREFERENCE
                where 
                    ID in (
                        select mp.ID
                        from MAILPREFERENCE mp
                            join MAILPREFERENCEGROUPCONTACT mpgc on mpgc.MAILPREFERENCEID=mp.ID
                        where mpgc.CONSTITUENTID=@CONSTITUENTID
                    )

                return 0;