UFN_DATALIST_DASHBOARDREFERENCES

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

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

    return;

end;