Home Forums SQL Server 2005 Administering Delete RE: Delete
ibidapo22
Valued Member
Points: 59
More actions
June 11, 2008 at 3:15 am
#827124
DELETE I
FROM tbItem I (nolock)
INNER JOIN tbProductionOrder PO (nolock)
ON I.POID = PO.POID
WHERE PODescription LIKE '%00000%'
This will delete about 11000000 records
Once again this has been successfully severally