UFN_QUERY_DATAFORMINSTANCEPAGEREFERENCES

CREATE function dbo.UFN_QUERY_DATAFORMINSTANCEPAGEREFERENCES(@DATAFORMINSTANCEID uniqueidentifier)
returns @TABLE table
(
    DATAFORMINSTANCEID uniqueidentifier,
    ID uniqueidentifier,
    NAME nvarchar(max),
    DESCRIPTION nvarchar(max),
    RECORDTYPE nvarchar(max)   
)
with execute as caller
as
begin
    insert into @TABLE
    select 
        @DATAFORMINSTANCEID,
        P.ID,
        P.UINAME as NAME,
        P.DESCRIPTION,
        R.NAME as RECORDTYPE
    from dbo.PAGEDEFINITIONCATALOG as P
        inner join dbo.UFN_DATAFORMINSTANCE_PAGEREFERENCES(@DATAFORMINSTANCEID) as T on P.ID = T.PAGEID
        left join dbo.RECORDTYPE as R on P.CONTEXTRECORDTYPEID = R.ID
    order by P.UINAME;

    return;

end;