/****** Departemen Pengawasan IKNB 1A  ******/
SELECT TOP (1000) [RegulationId]
      ,[RegulationRegulationTypeId]
      ,[RegulationIsBoardSeminar]
      ,[RegulationConditionId]
      ,[RegulationOrganizationId]
      ,[RegulationName]
      ,[RegulationDescription]
      ,[RegulationCreateBy]
      ,[RegulationCreateDate]
      ,[RegulationUpdateBy]
      ,[RegulationUpdateDate]
      ,[RegulationStep]
      ,[RegulationStepStatus]
      ,[RegulationStatus]
      ,[RegulationLogCode]
      ,[RegulationCancelBy]
      ,[RegulationCancelDate]
      ,[RegulationReason]
      ,[RegulationCancelStep]
      ,[RegulationRdkStatus]
      ,[RegulationRdkDate]
      ,[RegulationRdkNomor]
      ,[RegulationProlegId]
      ,[RegulationBoardSeminarUlang]
      ,[RegulationHarmonizationProcessDate]
      ,[RegulationNotaDinasNumber]
      ,[RegulationNotaDinasDate]
  FROM [SISIMPU].[Transaction].[Regulations]
WHERE
	RegulationName LIKE '%paydi%'

5, 9

----UPDATE [SISIMPU].[Transaction].[Regulations] SET RegulationStep = 6, RegulationStepStatus = 9 WHERE RegulationId = 1401 (batal pakai yang ini)
--UPDATE [SISIMPU].[Transaction].[Regulations] SET RegulationStep = 6, RegulationStepStatus = 12 WHERE RegulationId = 1401


SELECT * FROM [Transaction].[Finalitations] WHERE FinalitationRegulationId = 1401
--SELECT * INTO [Transaction].[Finalitations_backup] FROM [Transaction].[Finalitations] WHERE FinalitationRegulationId = 1401
SELECT * FROM [Transaction].[Finalitations_backup]
--DELETE FROM [Transaction].[Finalitations] WHERE FinalitationRegulationId = 1401

SELECT * FROM [Transaction].[Document] WHERE DocumentDataId = 1401
