UFN_FINANCIALTRANSACTION_HASDESIGNATIONS

create function dbo.UFN_FINANCIALTRANSACTION_HASDESIGNATIONS(@FINANCIALTRANSACTIONID uniqueidentifier)
returns bit
with execute as caller
as begin
    declare @TRANSACTIONDESIGNATIONCOUNT int = 0
    declare @TRANSACTIONHASDESIGNATIONS bit = 0

    select @TRANSACTIONDESIGNATIONCOUNT = count(D.ID)
    from INSTALLMENTSPLIT I
    join DESIGNATION D
        on I.PLEDGEID = @FINANCIALTRANSACTIONID
        and I.DESIGNATIONID = D.ID

    if @TRANSACTIONDESIGNATIONCOUNT > 0
        set @TRANSACTIONHASDESIGNATIONS = 1

    return @TRANSACTIONHASDESIGNATIONS 
end