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