title: Insert value into table
body: <p>I have below SQL query, am trying to insert data into test table, but I got another requirement that I need to insert the employee number along with his/her name.</p>
  
  <p>Example 
  firstname : 71853-osama   </p>
  
  <p>My question is, How I can insert two values into one attribute 
  I tried this </p>
  
  <pre><code> badgeno +'-'+ convert(nvarchar(100),cEmpname) as cEmpname 
  </code></pre>
  
  <p>but it didn't work </p>
  
  <pre><code>insert into PT ( 
        [FirstName]
        ,[LastName]
        ,[FirmID]
        ,[Note]
        ,[City]
        ,[ThirdPartyId]
        ,[RegisteredBy]
        ,[Registered]
        ,[LastUpdatedBy]
        ,[LastUpdated]
                   )
  
       SELECT distinct 
       convert(nvarchar(100),cEmpname) as cEmpname 
        ,convert(nvarchar(100),cJobTitle) as cJobTitle
        ,'2' as FirmID
        ,convert(nvarchar(500),sort1) as sort1
        ,convert(nvarchar(255),cnationality) as cnationality
       , badgeno as 'ThirdPartyId'
      ,'admin' as RegisteredBy
      ,CURRENT_TIMESTAMP  as Registered
       ,'admin' as  LastUpdatedBy
       , CURRENT_TIMESTAMP as LastUpdated
  
  
        FROM [TrailBlazerNG].[dbo].[payper] where lactive = '1' 
        and not exists ( select 1 from PT where payper.badgeno = PT.ThirdPartyId)
  </code></pre>