UFN_CONSTITUENTBATCH_GETSOCIALMEDIAACCOUNTS

CREATE function dbo.UFN_CONSTITUENTBATCH_GETSOCIALMEDIAACCOUNTS
(
    @BATCHCONSTITUENTID uniqueidentifier
)
returns table
as
return
    (
        select
            ID,
            SOCIALMEDIASERVICEID,
            USERID,
            URL,
            SOCIALMEDIAACCOUNTTYPECODEID,
            INFOSOURCECODEID,
            DONOTCONTACT,
            SEQUENCE
        from
            dbo.BATCHCONSTITUENTSOCIALMEDIAACCOUNT
        where
            BATCHCONSTITUENTID = @BATCHCONSTITUENTID
    )