-- 3847
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

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