
DECLARE @data TABLE
(
	nomor_ketentuan [varchar](20),
	nd_permintaan_pengundangan [varchar](25),
	tgl_terima_kemenkumham [date],
	nd_salinan_ketentuan [varchar](25)
) 

INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('13/POJK.03/2020', 'S-49/MS.61/2020', '2020-03-31', 'ND-32/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('14/POJK.05/2020', 'S-64/MS.61/2020', '2020-04-21', 'ND-49/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('15/POJK.04/2020 ', 'S-69/MS.61/2020', '2020-04-21', 'ND-47/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('16/POJK.04/2020', 'S-69/MS.61/2020', '2020-04-21', 'ND-47/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('17/POJK.04/2020', 'S-69/MS.61/2020', '2020-04-21', 'ND-47/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('18/POJK.03/2020', 'S-69/MS.61/2020', '2020-04-21', 'ND-41/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('19/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-56/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('20/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-56/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('21/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('22/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('23/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('24/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('25/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('26/POJK.04/2020 ', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('27/POJK.04/2020', 'S-74/MS.61/2020', '2020-04-23', 'ND-57/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('28/POJK.05/2020', 'S-77/MS.61/2020', '2020-04-28', 'ND-54/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('29/POJK.05/2020', 'S-77/MS.61/2020', '2020-04-28', 'ND-55/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('30/POJK.05/2020', 'S-77/MS.61/2020', '2020-04-28', 'ND-53/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('31/POJK.07/2020', 'S-77/MS.61/2020', '2020-04-28', 'ND-63/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('32/POJK.04/2020', 'S-78/MS.61/2020', '2020-05-05', 'ND-61/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('33/POJK.04/2020', 'S-95/MS.61/2020', '2020-05-28', 'ND-73/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('34/POJK.03/2020', 'S-99/MS.61/2020', '2020-06-02', 'ND-75/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('35/POJK.04/2020', 'S-100/MS.61/2020', '2020-06-02', 'ND-66/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('36/POJK.02/2020', 'S-100/MS.61/2020', '2020-06-02', 'ND-74/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('37/POJK.04/2020', 'S-101/MS.61/2020', '2020-06-11', 'ND-79/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('38/POJK.05/2020', 'S-107/MS.61/2020', '2020-06-16', 'ND-83/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('39/POJK.05/2020', 'S-107/MS.61/2020', '2020-06-16', 'ND-83/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('40/POJK.05/2020', 'S-107/MS.61/2020', '2020-06-16', 'ND-83/MS.6111/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('41/POJK.04/2020', 'S-115/MS.61/2020', '2020-07-02', 'ND-34/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('42/POJK.04/2020', 'S-115/MS.61/2020', '2020-07-02', 'ND-34/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('43/POJK.04/2020', 'S-115/MS.61/2020', '2020-07-02', 'ND-34/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('44/POJK.05/2020', 'S-3/MS.611/2020', '2020-09-01', 'ND-93/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('45/POJK.03/2020', 'S-5/MS.611/2020', '2020-10-15', 'ND-133/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('46/POJK.05/2020', 'S-6/MS.611/2020', '2020-11-03', 'ND-163/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('47/POJK.05/2020', 'S-7/MS.611/2020', '2020-11-26', 'ND-195/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('48/POJK.03/2020', 'S-9/MS.611/2020', '2020-12-03', 'ND-200/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('49/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('50/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('51/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('52/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('53/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('54/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('55/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('56/POJK.04/2020', 'S-10/MS.611/2020', '2020-12-08', 'ND-211/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('57/POJK.04/2020', 'S-11/MS.611/2020', '2020-12-11', 'ND-210/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('58/POJK.05/2020', 'S-12/MS.611/2020', '2020-12-15', 'ND-222/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('59/POJK.03/2020', 'S-12/MS.611/2020', '2020-12-15', 'ND-215/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('60/POJK.05/2020', 'S-12/MS.611/2020', '2020-12-15', 'ND-214/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('61/POJK.07/2020', 'S-13/MS.611/2020', '2020-12-15', 'ND-216/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('62/POJK.03/2020', 'S-14/MS.611/2020', '2020-12-17', 'ND-226/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('63/POJK.03/2020', 'S-15/MS.611/2020', '2020-12-22', 'ND-233/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('64/POJK.03/2020', 'S-16/MS.611/2020', '2020-12-29', 'ND-234/MS.611/2020')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('65/POJK.04/2020', 'S-17/MS.611/2020', '2020-12-30', 'ND-5/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('66/POJK.04/2020', 'S-17/MS.611/2020', '2020-12-30', 'ND-5/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('1/POJK.04/2021', 'S-2/MS.611/2021', '2021-01-19', 'ND-25/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('2/POJK.03/2021', 'S-3/MS.611/2021', '2021-02-18', 'ND-55/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('3/POJK.04/2021', 'S-4/MS.611/2021', '2021-02-23', 'ND-61/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('4/POJK.05/2021', 'S-5/MS.611/2021', '2021-03-16', 'ND-74/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('5/POJK.04/2021', 'S-5/MS.611/2021', '2021-03-16', 'ND-75/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('6/POJK.04/2021', 'S-5/MS.611/2021', '2021-03-16', 'ND-76/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('7/POJK.04/2021', 'S-7/MS.611/2021', '2021-03-18', 'ND-79/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('8/POJK.04/2021', 'S-8/MS.611/2021', '2021-03-18', 'ND-82/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('9/POJK.05/2021', 'S-9/MS.611/2021', '2021-06-29', 'ND-143/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('10/POJK.05/2021', 'S-10/MS.611/2021', '2021-07-01', 'ND-145/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('11/POJK.02/2021', 'S-11/MS.611/2021', '2021-07-06', 'ND-151/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('12/POJK.03/2021', 'S-12/MS.611/2021', '2021-08-18', 'ND-181/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('13/POJK.03/2021', 'S-12/MS.611/2021', '2021-08-18', 'ND-181/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('14/POJK.03/2021', 'S-12/MS.611/2021', '2021-08-18', 'ND-181/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('15/POJK.03/2021', 'S-13/MS.611/2021', '2021-08-24', 'ND-179/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('16/POJK.04/2021', 'S-14/MS.611/2021', '2021-08-26', 'ND-183/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('17/POJK.03/2021', 'S-15/MS.611/2021', '2021-09-13', 'ND-195/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('18/POJK.03/2021', 'S-15/MS.611/2021', '2021-09-13', 'ND-195/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('19/POJK.05/2021', 'S-16/MS.611/2021', '2021-09-15', 'ND-200/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('20/POJK.04/2021', 'S-17/MS.611/2021', '2021-09-21', 'ND-198/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('21/POJK.04/2021', 'S-18/MS.611/2021', '2021-11-30', 'ND-264/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('22/POJK.04/2021', 'S-20/MS.611/2021', '2021-12-02', 'ND-266/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('23/POJK.04/2021', 'S-21/MS.611/2021', '2021-12-06', 'ND-270/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('24/POJK.04/2021', 'S-21/MS.611/2021', '2021-12-06', 'ND-270/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('25/POJK.03/2021', 'S-22/MS.611/2021', '2022-12-15', 'ND-284/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('26/POJK.03/2021', 'S-23/MS.611/2021', '2021-12-20', 'ND-290/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('27/POJK.03/2021', 'S-24/MS.611/2021', '2021-12-27', 'ND-297/MS.611/2021')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('28/POJK.03/2021', 'S-25/MS.611/2021', '2022-01-03', 'ND-4/MS.611/2022')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('29/POJK.04/2021', 'S-26/MS.611/2021', '2022-01-03', 'ND-5/MS.611/2022')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('30/POJK.05/2021', 'S-26/MS.611/2021', '2022-01-03', 'ND-11/MS.611/2022')
INSERT INTO @data (nomor_ketentuan, nd_permintaan_pengundangan, tgl_terima_kemenkumham, nd_salinan_ketentuan) VALUES ('1/POJK.03/2022', 'S-1/MS.611/2022', '2022-01-06', 'ND-12/MS.611/2022')

SELECT 
	f.FinalitationRegulationId,
	f.FinalitationRdkId,
	d.nd_permintaan_pengundangan,
	NULL, -- tanggal ND
	NULL, -- id dokumen ND
	d.tgl_terima_kemenkumham,
	'',	-- catatan
	d.nd_salinan_ketentuan,
	NULL, -- tanggal ND
	0,	-- CreateBy
	GETDATE(),	-- CreateDate
	NULL,	-- UpdateBy
	NULL	-- UpdateDate
FROM 
	@data AS d
	LEFT JOIN
	[Transaction].[Finalitations] AS f ON d.nomor_ketentuan = f.FinalitationRegulationNumber
	LEFT JOIN
	[Transaction].[Regulations] AS r ON f.FinalitationRegulationId = r.RegulationId
WHERE
--	f.FinalitationId IS NULL
	f.FinalitationId IS NOT NULL
