UFN_QUERY_DASHBOARDDATALISTS

CREATE function dbo.UFN_QUERY_DASHBOARDDATALISTS
(
    @DASHBOARDID uniqueidentifier
)
returns @TABLE table
(
    DASHBOARDID uniqueidentifier,
    ID uniqueidentifier,
    NAME nvarchar(max),
    DESCRIPTION nvarchar(max),
    RECORDTYPE nvarchar(max)   
)
with execute as caller
as
begin
    insert into @TABLE
    select 
        @DASHBOARDID,
        D.ID,
        D.UINAME as NAME,
        D.DESCRIPTION,
        RT.NAME as RECORDTYPE
    from dbo.DATALISTCATALOG as D
        inner join dbo.UFN_DASHBOARD_DATALISTREFERENCES(@DASHBOARDID) as T on D.ID = T.DATALISTID
        left join dbo.RECORDTYPE as RT on D.RECORDTYPEID = RT.ID
    order by D.UINAME;

    return;

end;