CREATE TABLE #TEXTFILE_1(
    FIELD1 varchar(100) );

BULK INSERT #TEXTFILE_1 FROM 'C:\stuff.txt'
WITH (FIELDTERMINATOR = '\t',
    ROWTERMINATOR = '\n');

WITH CTE AS (
Select DISTINCT
SYS.Netbios_Name0 as "Computer Name",
AR.Publisher0 as 'Vendor',
AR.DisplayName0 AS 'Software name',
AR.Version0 as 'Software Version'
FROM v_GS_ADD_REMOVE_PROGRAMS AR
JOIN
v_R_System SYS ON AR.ResourceID=SYS.ResourceID
JOIN
v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE sys.Name0 LIKE 'COMPUTERNAME%')

SELECT DISTINCT A.* FROM CTE A 
WHERE NOT EXISTS (SELECT 1 FROM #TEXTFILE_1 B WHERE A.[Software name] LIKE '%'+B.FIELD1+'%' )
ORDER BY A.[Computer Name],A.Vendor,A.[Software name],A.[Software Version]

DROP TABLE  #TEXTFILE_1