Update cust Set LastName = Json.FirstName From OPENJSON (@jsonData) WITH (FirstName nvarchar(20), LastName nvarchar(20)) As Json Inner Join dbo.Customers As cust On cust.LastName = Json.LastName; Of ...