SELECT * FROM dbo.Note_Terbit_Master WHERE No_Ref='2014.079650'
SELECT * FROM dbo.Note_Terbit_Detail WHERE No_Ref='2014.079650'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079605'
-- 1.
SELECT * FROM dbo.Note_Terbit_Master WHERE No_Ref='2014.079411'
--UPDATE dbo.Note_Terbit_Master SET Look_Ref='2014.079411' WHERE No_Ref='2014.079411'
SELECT * FROM dbo.Note_Terbit_Detail WHERE No_Ref='2014.079411'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079411'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014x079605' WHERE No_Ref='2014.079605'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014x079605' WHERE No_Ref='2014.079605'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014x079605' WHERE No_Ref='2014.079605'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079605' WHERE No_Ref='2014.079411'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079605' WHERE No_Ref='2014.079411'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079605' WHERE No_Ref='2014.079411'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079411' WHERE No_Ref='2014x079605'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079411' WHERE No_Ref='2014x079605'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079411' WHERE No_Ref='2014x079605'

----------------------------------
--2.
--UPDATE dbo.Note_Terbit_Master SET Look_Ref='2014.079412' WHERE No_Ref='2014.079412'
SELECT * FROM dbo.Note_Terbit_Master WHERE No_Ref='2014.079412'
SELECT * FROM dbo.Note_Terbit_Detail WHERE No_Ref='2014.079412'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079412'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079644'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014x079644' WHERE No_Ref='2014.079644'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014x079644' WHERE No_Ref='2014.079644'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014x079644' WHERE No_Ref='2014.079644'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079644' WHERE No_Ref='2014.079412'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079644' WHERE No_Ref='2014.079412'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079644' WHERE No_Ref='2014.079412'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079412' WHERE No_Ref='2014x079644'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079412' WHERE No_Ref='2014x079644'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079412' WHERE No_Ref='2014x079644'

----------------------------------
--3.
--UPDATE dbo.Note_Terbit_Master SET Look_Ref='2014.079413' WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Note_Terbit_Master WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Note_Terbit_Detail WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079650'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014x079650' WHERE No_Ref='2014.079650'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014x079650' WHERE No_Ref='2014.079650'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014x079650' WHERE No_Ref='2014.079650'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'

--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079413' WHERE No_Ref='2014x079650'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014x079650'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014x079644'
--______________________________________________________________________________________________________________

SELECT * FROM dbo.Note_Terbit_Master WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Note_Terbit_Detail WHERE No_Ref='2014.079413'
SELECT * FROM dbo.Peserta_Produk_Detail WHERE No_Ref='2014.079413'

----UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'
----UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'
----UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079650' WHERE No_Ref='2014.079413'
--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079413' WHERE No_Ref='2014.079650'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014.079650'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014.079650'

----UPDATE dbo.Note_Terbit_Master SET No_Ref='2014.079413' WHERE No_Ref='2014x079650'
----UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014x079650'
----UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014.079413' WHERE No_Ref='2014x079650'
--UPDATE dbo.Note_Terbit_Master SET No_Ref='2014x079650' WHERE No_Ref='2014.079413'
--UPDATE dbo.Note_Terbit_Detail SET No_Ref='2014x079650' WHERE No_Ref='2014.079413'
--UPDATE dbo.Peserta_Produk_Detail SET No_Ref='2014x079650' WHERE No_Ref='2014.079413'

--2014.079605 --> 2014.079411 
--2014.079644 --> 2014.079412 
--2014.079650 --> 2014.079413 

--UPDATE dbo.Note_Terbit_Master SET Jenis=1 WHERE No_Ref='2014.079413'