Home Forums SQL Server 2005 T-SQL (SS2K5) find item that does not have a specific entry RE: find item that does not have a specific entry

  • December 31, 2012 at 10:44 am

    #1572553

    lawson2305 (12/31/2012)

    Ok here is a sql I run that tells me all my machines that have java installed.

    SELECT DISTINCT i.guid, i.name

    FROM dbo.Inv_Installed_File_Details fd

    JOIN vComputer i ON i.Guid = fd._ResourceGuid

    where fd.path LIKE 'c:\Program files%\Java\%' and fd.name = 'java.exe'

    Order by i.name

    I would like to reverse this and get the results that do not match the where clause. I need help in writing figuring this out. I have played around with some things that just don't seem to give me what I need.

    Thanks for any help you can provide.

    You mean like this:

    SELECT DISTINCT i.guid, i.name

    FROM

    dbo.Inv_Installed_File_Details fd

    JOIN vComputer i

    ON i.Guid = fd._ResourceGuid

    where

    NOT(fd.path LIKE 'c:\Program files%\Java\%' and fd.name = 'java.exe')

    Order by i.name