CREATE TABLE Employee
 (
  userID INT IDENTITY(1,1) NOT NULL,
  userName VARCHAR(50) NULL,
  FirstName VARCHAR(50) NULL,
  LastName VARCHAR(50) NUll,
  UserPassWd VARCHAR(50) NULL

  CONSTRAINT PK_Employee PRIMARY KEY (userID)
 )

DECLARE @FIRSTNAME VARCHAR(50)
DECLARE @LASTNAME VARCHAR(50)
DECLARE @USERPASS VARCHAR(100)
DECLARE @USERNAME VARCHAR(50)
DECLARE @EMAIL VARCHAR(100)
DECLARE @USERID INT

SELECT   @USERID = userID
        ,@USERNAME = userName
        ,@FIRSTNAME = FirstName
        ,@LASTNAME = LastName
        ,@USERPASS = UserPassword
        ,@EMAIL =  EmailId

FROM    Employee

WHERE   userID = 1004


INSERT INTO UserEmail
    (
        EmailAddress
       ,EmailTypeID
       ,ExternalUserID
       ,Active
       ,CreatedByID
       ,CreatedDate
       ,UpdatedByID
       ,UpdatedDate

    )

SELECT  @EMAIL  -- Email Address
    ,1          -- Email Type
    ,1          -- ExternalUserID
    ,1          -- Active
    ,1          -- CreatedByID
    ,CONVERT(INT,CURRENT_TIMESTAMP) -- CreatedDate
    ,1
    ,CONVERT(INT,CURRENT_TIMESTAMP) -- UpdatedDate

FROM    Employee X

WHERE   1=1
        AND X.userID = '####'-- INSERT USERID HERE for testing