USE [GrpInsurance]
GO

SELECT
  *
FROM
  Enrollment
WHERE
  No_Proposal = '2015.0254'
  AND Tgl_Proses = '2015-06-18'


SELECT
  *
FROM
  Enrollment
WHERE
  No_Proposal IN ('2015.0254', '2015.0253')
  AND Tgl_Proses = '2015-06-18'
--UPDATE Enrollment SET Status='G' WHERE No_Proposal IN ('2015.0254', '2015.0253') AND Tgl_Proses='2015-06-18'


--UPDATE Enrollment SET MD_001='13', MD_015='20150814' WHERE No_Proposal = '2015.0317' AND Tgl_Proses = '2015-07-10'
--UPDATE Enrollment SET MD_001='13', MD_015='20150814' WHERE No_Proposal IN ('2015.0254', '2015.0253') AND Tgl_Proses = '2015-06-18'


--UPDATE Enrollment SET MD_015='201301471', MD_019='20150814' WHERE No_Proposal = '2015.0254' AND Tgl_Proses = '2015-06-18' AND MD_015='20150814'

SELECT
  *
FROM
  Enrollment
WHERE
  No_Proposal = '2015.0253'
  AND Tgl_Proses = '2015-06-18'

--UPDATE Enrollment SET MD_015='201201561', MD_019='20150814' WHERE No_Proposal = '2015.0253' AND Tgl_Proses = '2015-06-18' AND MD_015='20150814'

SELECT
  *
FROM
  Enrollment
WHERE
  No_Proposal = '2015.0317'
  AND Tgl_Proses = '2015-07-10'
  
--UPDATE Enrollment SET MD_015='201401201', MD_019='20150814' WHERE No_Proposal = '2015.0317' AND Tgl_Proses = '2015-07-10' AND MD_015='20150814'