UFN_QUERY_DATALISTDASHBOARDREFERENCES

CREATE function dbo.UFN_QUERY_DATALISTDASHBOARDREFERENCES
(
    @DATALISTID uniqueidentifier
)
returns @TABLE table
(
    DATALISTID uniqueidentifier,
    ID uniqueidentifier,
    NAME nvarchar(max),
    DESCRIPTION nvarchar(max),
    RECORDTYPE nvarchar(max)   
)
with execute as caller
as
begin

    insert into @TABLE
    select 
        @DATALISTID,
        D.ID,
        D.NAME,
        D.DESCRIPTION,
        R.NAME as RECORDTYPE
    from dbo.DASHBOARDCATALOG as D
        inner join dbo.UFN_DATALIST_DASHBOARDREFERENCES(@DATALISTID) as T on D.ID = T.DASHBOARDID
        left join dbo.RECORDTYPE as R on D.CONTEXTRECORDTYPEID = R.ID
    order by D.NAME;

    return;

end;