Try this...

DELETE FROM tbItem l (nolock)

Where exists(Select p.POID From tbProductionOrder p (nolock) where l.POID = p.POID AND PODescription LIKE '%00000%')

Use bulk insert...

--Step 1:create table to insert data from file

Create Table TmpTbl

(Column names

)

--Step 1: Build Valid BULK INSERT Statement

Set @FilePath = 'c:\test.txt'

EXEC Master..xp_fileexist @FilePath, @File_Exists OUT

IF @File_Exists = 1...