update two tables in one statement in SQL Server

ALTER PROCEDURE [dbo].[UpdateUserProfile]

(

  @EmailID NVARCHAR(150)

 ,@FirstName NVARCHAR(100)

 ,@LastName NVARCHAR(100)

 ,@Mobile NVARCHAR(15)

 ,@AlternateContact NVARCHAR(15)

 ,@Gender CHAR(1)

 ,@DOB datetime

 ,@Address NVARCHAR(MAX)

 ,@ShortBio NVARCHAR(MAX)

)

AS

BEGIN

DECLARE @REST INT

SET @REST = (SELECT COUNT(*) FROM UserProfile WHERE EmailId =@EmailID)

IF(@REST = 0)   

     INSERT INTO UserProfile(

             EmailId

            ,Gender

            ,DOB

            ,Address

            ,ShortBio

            ,CreateDate

            ,UpdateDate

            ,IsDeleted

   )

   VALUES(

            @EmailID,

            @Gender,

            @DOB,

            @Address,

            @ShortBio,

            GETDATE(),

            GETDATE(),

            0

   ) 

ELSE

  --Update AspNetUsers Table1.

    UPDATE AspNetUsers

    SET  AspNetUsers.FirstName = @FirstName,

             AspNetUsers.LastName = @LastName,

             AspNetUsers.Mobile = @Mobile,

             AspNetUsers.AlternateContact = @AlternateContact

   FROM AspNetUsers T1, UserProfile T2

   WHERE T1.UserName = T2.EmailId AND T2.EmailId =@EmailID

  

      --Update UserProfile Table2.

    UPDATE UserProfile

     SET UserProfile.Gender = @Gender,

             UserProfile.DOB = @DOB,

             UserProfile.Address = @Address,

             UserProfile.ShortBio = @ShortBio,

             UserProfile.UpdateDate = GETDATE()

   FROM AspNetUsers T1, UserProfile T2

   WHERE T1.UserName = T2.EmailId AND T2.EmailId =@EmailID  

END