UFN_DASHBOARD_DATALISTREFERENCES

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

    with xmlnamespaces ('bb_appfx_flashdash' as tns, 'bb_appfx_commontypes' as common)
    insert into @TABLE
        select distinct dashboard.datalists.value('@DataListID', 'uniqueidentifier')
        from dbo.DASHBOARDCATALOG as D
            cross apply D.SPECXML.nodes('tns:FlashDashSpec/tns:XmlDataItems/tns:XmlData/tns:DataLists/tns:DataList') as dashboard(datalists)
        where D.ID = @DASHBOARDID

    return;

end;