UFN_PROCESSORTRANSACTIONSETTLEMENTIMPORT_GETIDFROMMD5SUM

        create function dbo.UFN_PROCESSORTRANSACTIONSETTLEMENTIMPORT_GETIDFROMMD5SUM
        (
            @MD5SUM nvarchar(32)
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            return (
                select 
                    ID
                from dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORT
                where MD5SUM = @MD5SUM
            )
        end