UFN_DASHBOARD_PRODUCTISDASHBOARD

      create function dbo.UFN_DASHBOARD_PRODUCTISDASHBOARD(@DASHBOARDID uniqueidentifier)
      returns bit
      with execute as caller
      as begin
          declare @ISPRODUCT bit = 0;

          with xmlnamespaces(default 'bb_appfx_flashdash', 'bb_appfx_commontypes' as common)
          select @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(
                      DASHBOARDCATALOG.SPECXML.query('/FlashDashSpec/common:InstalledProductList')
                  )
          FROM dbo.DASHBOARDCATALOG
          WHERE ID = @DASHBOARDID;

          RETURN @ISPRODUCT;  
      end