[Hamza FiGo]

تمت الموافقة

USE SRO_VT_SHARD 
GO 
Declare @ItemCode VarChar(Max) = '%TOKEN%'
DELETE _RefDropItemAssign 
FROM _RefDropItemAssign Drops 
LEFT JOIN _RefObjCommon Objects 
ON (Drops.RefitemID = Objects.ID) 
WHERE codename128 like @ItemCode