Use [SRO_VT_SHARD] Declare @CharName Varchar(60) , @Plus Int , @Slot Int Set @CharName = 'iLegend' Set @Plus = '10' Set @Slot = '13' Update [dbo].[_Items] Set OptLevel = @Plus Where ID64 = (Select ItemID From [dbo].[_Inventory] As Inv Inner Join [dbo].[_Char] As Char ON Inv.CharID = Char.CharID Where Inv.Slot = @Slot and Char.CharName16 = @CharName)