update [WebSales] SET W.Price = t.Price,W.SaleDate = t.SaleDate,W.CustomerID = t.CustomerID 
FROM [WebSales] W
inner join
(
  SELECT   
  ProductID,  
  Price,  
  SaleDate,  
  SaleBatchID,  
  CustomerID  
  FROM   
  OPENXML (@Pointer, '/ShoppingCart/Purchase ')   
  WITH   
  (   
  ProductID INT,   
  Price MONEY,   
  SaleDate SMALLDATETIME,   
  SaleBatchID INT,   
  CustomerID INT   
  )
) t
on W.ProductID=t.ProductID