SELECT
reports.name AS ReportName,
Datasource.Name AS datasource
FROM dbo.Catalog reports
INNER JOIN dbo.DataSource ON DataSource.ItemID = reports.ItemID
WHERE reports.Type = 2
AND NOT EXISTS (SELECT * FROM dbo.Catalog datasources
WHERE datasources.ItemID = DataSource.Link
-- 5 is shared
AND datasources.Type = 5
);
reports.name AS ReportName,
Datasource.Name AS datasource
AND datasources.Type = 5
Comments
Post a Comment