UFN_CONSTITUENT_GETSOCIALMEDIAACCOUNTS_FORUPDATEBATCH

            CREATE function dbo.UFN_CONSTITUENT_GETSOCIALMEDIAACCOUNTS_FORUPDATEBATCH
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as return

                select
                    SOCIALMEDIAACCOUNT.SOCIALMEDIASERVICEID,
                    coalesce(SOCIALMEDIAACCOUNT.USERID,'') as USERID,
                    coalesce(SOCIALMEDIAACCOUNT.URL,'') as URL,
                    SOCIALMEDIAACCOUNT.SOCIALMEDIAACCOUNTTYPECODEID,
                    SOCIALMEDIAACCOUNT.INFOSOURCECODEID,
                    coalesce(SOCIALMEDIAACCOUNT.DONOTCONTACT, cast(0 as bit)) as DONOTCONTACT,
                    SOCIALMEDIAACCOUNT.ID as SOCIALMEDIAACCOUNTID,
                    SOCIALMEDIAACCOUNT.SEQUENCE
                from
                    dbo.SOCIALMEDIAACCOUNT
                where
                    CONSTITUENTID = @CONSTITUENTID and
                    (WPMATCHCODE = '' or CONFIRMED = 1); --Only display if confirmed, or it was manually added by a user. Non-confirmed SMA records are only for display in the Prospects area.