UFN_QUERY_SIMPLEDATALISTDATAFORMREFERENCES

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

    return;

end;