UFN_QUERY_SEARCHLISTDATAFORMREFERENCES

CREATE function dbo.UFN_QUERY_SEARCHLISTDATAFORMREFERENCES
(
    @SEARCHLISTID uniqueidentifier
)
returns @TABLE table
(
    SEARCHLISTID uniqueidentifier,
    ID uniqueidentifier,
    NAME nvarchar(max),
    DESCRIPTION nvarchar(max) 
)
with execute as caller
as
begin
    insert into @TABLE
    select 
        @SEARCHLISTID,
        INSTANCE.ID,
        INSTANCE.UINAME as NAME,
        TEMPLATE.DESCRIPTION
    from dbo.DATAFORMINSTANCECATALOG as INSTANCE
        inner join dbo.UFN_SEARCHLIST_DATAFORMREFERENCES(@SEARCHLISTID) as T on INSTANCE.ID = T.DATAFORMINSTANCEID
        inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
    order by INSTANCE.UINAME;

    return;

end;