使用if语句的查询中的查询取决于结果

Question

因此，我对我创建的SSRS报告有一个奇怪的问题。

SELECT        rs.Name0, rs.User_Name0, rs.AD_Site_Name0, rs.User_Domain0, rs.Full_Domain_Name0, rs.Operating_System_Name_and0, eps.Active, eps.EpInstalled, eps.EpProtected, 
                         dbo.v_GS_AntimalwareHealthStatus.Enabled, dbo.v_GS_AntimalwareHealthStatus.Version, dbo.v_GS_AntimalwareHealthStatus.AntivirusEnabled, dbo.v_GS_AntimalwareHealthStatus.AntispywareEnabled, 
                         dbo.v_GS_AntimalwareHealthStatus.EngineVersion, eps.EpToBeInstalled,
                             (SELECT        rua.ProductName0
                               FROM            dbo.v_GS_CCM_RECENTLY_USED AS rua
                               WHERE        (rs.ressourceID = rua.ressourceID)) AS Kaspersky
FROM            dbo.v_R_System AS rs INNER JOIN
                         dbo.v_EndpointProtectionStatus AS eps ON rs.ResourceID = eps.ResourceID INNER JOIN
                         dbo.v_GS_AntimalwareHealthStatus ON rs.ResourceID = dbo.v_GS_AntimalwareHealthStatus.ResourceID INNER JOIN
                         dbo.v_GS_CCM_RECENTLY_USED_APPS AS rua ON rs.ResourceID = rua.ResourceID

为了更快，我正在尝试选择是否在机器上启用了端点，以及是否还存在卡巴斯基。但是我想不出来！我不知道如何管理它，因为这个查询：

(SELECT        rua.ProductName0
                               FROM            dbo.v_GS_CCM_RECENTLY_USED AS rua
                               WHERE        (rs.ressourceID = rua.ressourceID)) AS Kaspersky

它返回多行(因为它们是安装在目标计算机集合上的kaspersky的多个版本。但我需要的是，如果它返回一些东西(因为这意味着机器上有卡巴斯基)，那么就返回类似"True“或" it 's installed”的东西。

我已经有一段时间没有做一些SQL查询了，所以如果你能帮我的话，提前感谢你。

Answer 1

所以我终于找到了答案，它是这样的：

SELECT      rs.Name0, 
            rs.User_Name0, 
            rs.AD_Site_Name0, 
            rs.User_Domain0, 
            rs.Full_Domain_Name0, 
            rs.Operating_System_Name_and0, 
            eps.Active, 
            eps.EpInstalled, 
            eps.EpProtected, 
            eps.EpToBeInstalled,

            Case WHEN EXISTS (SELECT rua.ProductName0 FROM v_GS_CCM_RECENTLY_USED_APPS AS rua WHERE rs.resourceID = rua.resourceID AND rua.ProductName0 LIKE '%Kaspersky%') 
            THEN 'Yes'
            ELSE 'No'
            END AS "Is Kaspersky installed?"

FROM            v_R_System AS rs INNER JOIN
                v_EndpointProtectionStatus AS eps ON rs.ResourceID = eps.ResourceID