UFN_DASHBOARD_PAGEREFERENCES

create function dbo.UFN_DASHBOARD_PAGEREFERENCES
(
    @DASHBOARDID uniqueidentifier
)
returns @TABLE table
(
    PAGEID uniqueidentifier
)
with execute as caller
as
begin

    -- find pages that use this dashboard

    with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
    insert into @TABLE
        select distinct P.ID
        from dbo.PAGEDEFINITIONCATALOG as P
            cross apply P.PAGEDEFINITIONSPEC.nodes('//tns:Dashboard') as page(dashboardsections)
        where page.dashboardsections.value('@ID', 'uniqueidentifier') = @DASHBOARDID;

    return;

end;