--SELECT
--  *
--FROM
--  dbo.Klaim_Peserta
--WHERE
--  No_Proposal = '2014.0326'
--  AND Status = 'G'
  
DECLARE @list_klaim TABLE ( no_klaim VARCHAR(11))

INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.253477')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252464')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.249313')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.249801')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.251571')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252638')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.244355')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.247100')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.248571')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.250763')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.251534')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252157')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252379')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252394')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.226073')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.227912')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.229616')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.229630')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.235979')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.236005')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.238841')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.244414')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.245676')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.247013')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.249893')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.250886')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.251543')
INSERT INTO @list_klaim ( no_klaim ) VALUES ('2015.252198')

--SELECT
--	kp.*
--FROM
--	dbo.Klaim_Peserta AS kp INNER JOIN
--	@list_klaim ON kp.No_Klaim = [@list_klaim].no_klaim

UPDATE
	kp
SET
  No_Proposal = '2015.0254'
FROM
	dbo.Klaim_Peserta AS kp INNER JOIN
	@list_klaim ON kp.No_Klaim = [@list_klaim].no_klaim
	
UPDATE
	dbo.Klaim_Peserta
SET
  No_Proposal = '2015.0254'
WHERE
  No_Klaim IN ('2015.254030','2015.254728')