Cacher is the code snippet organizer for pro developers

SELECT
      [Bulletin] = [conn1].[Name]
      , [PolicyEnabled_Policy] = [conn4].[Enabled]
      , [PolicyEnabled_Web] = (SELECT COUNT(1) FROM [vPMCore_SoftwareUpdateAdvertisementSetPolicy] WHERE [Name] = [conn1].[Name])
FROM
	[vPMCore_SoftwareBulletin] [conn1]
    -- Policy Information
	LEFT JOIN [ItemActive] [conn4] on [conn1].[Guid] = [conn4].[Guid]
WHERE 1=1
AND (SELECT COUNT(1) FROM [vPMCore_SoftwareUpdateAdvertisementSetPolicy] WHERE [Name] = [conn1].[Name]) = 0
AND [conn4].[Enabled] = 1
ORDER BY [conn1].[Name]