UFN_DATAFORMINSTANCE_EXISTS_BYMODE

create function dbo.UFN_DATAFORMINSTANCE_EXISTS_BYMODE (@ID as uniqueidentifier, @MODE as smallint)
returns bit
with execute as caller
as
begin
    if exists(select DATAFORMINSTANCECATALOG.ID 
            from dbo.DATAFORMINSTANCECATALOG 
            inner join dbo.DATAFORMTEMPLATECATALOG on DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOG.ID
            where DATAFORMINSTANCECATALOG.ID = @ID and DATAFORMTEMPLATECATALOG.MODE = @MODE)

        return 1;

    return 0;
end