CREATE PROCEDURE [dbo].[Insert_User]
      @Username NVARCHAR(100)

AS
BEGIN
      SET NOCOUNT ON;
      IF EXISTS(SELECT userid FROM registered WHERE Username = @Username)
      BEGIN
            SELECT -1 -- Username exists.
      END


      ELSE
      BEGIN
            INSERT INTO [registered]
                     ([Username]
                     ,[CreatedDate],
[password])
            VALUES
                     (@Username

                     ,GETDATE()
, '123')


UPDATE R
SET R.email = P.email
FROM dbo.registered AS R
INNER JOIN dbo.registeredusers AS P
       ON R.username = P.username;


            SELECT SCOPE_IDENTITY() -- UserId
     END

BEGIN

TRUNCATE TABLE loginuser
INSERT INTO loginuser (username, email, password)
SELECT username, email, password
FROM registered

END
END