SELECT
  tmp.[No],
  tmp.[NIK],
  tmp.[NAMA],
  pst.Nama,
  tmp.Tgl_Lahir,
  tmp.[F5],
  tmp.[Sex],
  tmp.[Nama Bank],
  tmp.[No Rekening],
  tmp.[Account],
  tmp.[Nomer Telephone],
  tmp.[Alamat Email]
FROM
  [db_no_replicate_space].[dbo].[temp_prib_peserta_saranamultiinfrastruktur] AS tmp INNER JOIN  -- 656
  dbo.Peserta AS pst ON tmp.NIK = pst.Nik
                        AND tmp.Tgl_Lahir = pst.Tgl_Lahir
                        --AND tmp.NAMA = pst.Nama -- 232
WHERE
  pst.No_Proposal = '2016.0587'
  
--SELECT
--	*
--FROM
--	dbo.Peserta_handphone
--WHERE
--  --No_Proposal = '2016.0587'
--  No_Polis = '2016.0140.1'

INSERT INTO dbo.Peserta_handphone
        (No_Polis,
         No_Peserta,
         handphone1,
         Status,
         Create_By,
         Create_Date,
         email)
SELECT
  '2016.0140.1', -- No_Polis - varchar(11)
  pst.No_Peserta,
  tmp.[Nomer Telephone],
  'I', -- Status - varchar(1)
  'SUP', -- Create_By - varchar(4)
  GETDATE(), -- Create_Date - datetime
  tmp.[Alamat Email]
FROM
  [db_no_replicate_space].[dbo].[temp_prib_peserta_saranamultiinfrastruktur] AS tmp INNER JOIN  -- 656
  dbo.Peserta AS pst ON tmp.NIK = pst.Nik
                        AND tmp.Tgl_Lahir = pst.Tgl_Lahir
                        --AND tmp.NAMA = pst.Nama -- 232
WHERE
  pst.No_Proposal = '2016.0587'