SELECT
  tpimg.no_urut,
	p.No_Proposal,
	tpimg.nama_prs,
	p.No_Peserta,
	p.Nama,
	p.Grade,
	tpimg.grade AS Grade_Baru
FROM
	dbo.temp_prib_import_map_grade AS tpimg INNER JOIN
	dbo.Peserta AS p ON tpimg.no_proposal = p.No_Proposal
	                    AND tpimg.no_peserta = p.No_Peserta
ORDER BY
  tpimg.no_urut


--UPDATE
--  p
--SET
--  Grade = tpimg.grade
--FROM
--	dbo.temp_prib_import_map_grade AS tpimg INNER JOIN
--	dbo.Peserta AS p ON tpimg.no_proposal = p.No_Proposal
--	                    AND tpimg.no_peserta = p.No_Peserta