[BashA_Mn_Youme]

انا عايز بروسيدر Remove adv بس يكون غير ده علشان ده مش شغال

   if(@JobID= '34003') -- Remover ADV Ticket added by CHE
		begin 
		Select @CharName16=CharName16 from _Char where CharID = @CharID 
		begin
		DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory 
		WHERE  CharID=@CharID) and bOptType=2
		end
		end