Select to Delete conversion

Hi Neil

Try this (in a test environment!)

delete tab1 
FROM  [Profile] TAB1 
INNER JOIN 
(SELECT [Col1] AS [ID],[Col2] AS [FileID] 
 FROM [SupData] 
WHERE UPPER([DSet]) = N'TEST'
)TAB2 
ON TAB1.[ID]=TAB2.[ID]
AND TAB1.[FileID] = TAB2.[FileID]