UFN_CONSTITUENTBATCH_VALIDATESOCIALMEDIAACCOUNTS

create function dbo.UFN_CONSTITUENTBATCH_VALIDATESOCIALMEDIAACCOUNTS
(
@SOCIALMEDIAACCOUNTS xml
)
returns bit
with execute as caller
as begin
    if exists(select 1 from dbo.UFN_CONSTITUENTBATCH_GETSOCIALMEDIAACCOUNTS_FROMITEMLISTXML(@SOCIALMEDIAACCOUNTS) ACCOUNTS group by ACCOUNTS.SOCIALMEDIASERVICEID,ACCOUNTS.URL having count(*) > 1)
    begin
        return 0;
    end

    return 1;
end