UFN_BATCHCONSTITUENTUPDATE_GETSOCIALMEDIAACCOUNTS

create function dbo.UFN_BATCHCONSTITUENTUPDATE_GETSOCIALMEDIAACCOUNTS
(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
)
returns table
as
return
    (
        select
            ID,
            SOCIALMEDIASERVICEID,
            USERID,
            URL,
            SOCIALMEDIAACCOUNTTYPECODEID,
            INFOSOURCECODEID,
            DONOTCONTACT,
            SEQUENCE,
            SOCIALMEDIAACCOUNTID
        from
            dbo.BATCHCONSTITUENTUPDATESOCIALMEDIAACCOUNT
        where
            BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
    )