USP_PHONE_UPDATEUNFORMATTEDNUMBERS

create procedure dbo.USP_PHONE_UPDATEUNFORMATTEDNUMBERS
(
  @PHONES xml,
  @CHANGEAGENTID uniqueidentifier = null
)
as
begin
  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @CURRENTDATE datetime = getdate();

  update dbo.PHONE
  set
    NUMBER = INPUT.NUMBER,
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = @CURRENTDATE
  from (
    select
      T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
      T.c.value('(NUMBER)[1]','nvarchar(100)') AS 'NUMBER'
    from @PHONES.nodes('/PHONES/ITEM') T(c)
  ) INPUT
  where PHONE.ID = INPUT.ID;
end