DECLARE @tableCopy TABLE
(
    BusinessEntityID INT NOT NULL,
    PersonType NCHAR(2) NOT NULL,
    NameStyle dbo.NameStyle NOT NULL,
    Title NVARCHAR(8) NULL,
    FirstName dbo.Name NOT NULL,
    MiddleName dbo.Name NULL,
    LastName dbo.Name NOT NULL,
    Suffix NVARCHAR(5) NULL,
    EmailPromotion INT NOT NULL,
    ModifiedDate DATETIME NOT NULL,
    ID BIGINT IDENTITY(10,10) NOT NULL,
    FullName NVARCHAR(100) NULL
)

SELECT * FROM @tableCopy

INSERT INTO @tableCopy(BusinessEntityID,PersonType,NameStyle,Title,FirstName,MiddleName,LastName,Suffix,EmailPromotion,ModifiedDate,FullName)
    SELECT p.BusinessEntityID,PersonType,NameStyle,(CASE e.Gender WHEN 'M' THEN 'Mr.' WHEN 'F' THEN 'Ms.' ELSE '' END),FirstName,MiddleName,LastName,Suffix,EmailPromotion,p.ModifiedDate,FullName
    FROM dbo.Person as p
        INNER JOIN
        HumanResources.Employee as e
        ON p.BusinessEntityID = e.BusinessEntityID

SELECT * FROM @tableCopy