Untitled

update [BSI].[mrms].[lcr_parameter]
set currentStatus =0

SELECT TOP (1000) [id]
      ,[reportDate]
      ,[currentStatus]
      ,[lpsIdr]
      ,[lpsValas]
      ,[grossRevenue]
      ,[createdAt]
      ,[createdById]
      ,[createdByName]
      ,[createdByEmail]
  FROM [BSI].[mrms].[lcr_report]
 
 
  SELECT count(*) total_scheduler, sum(proyeksi) jumlah FROM [bsi].[mis].[DS_REAL_PROJ_SCHEDULE_N_20230529]
SELECT count(*) total_customer FROM [bsi].[mis].[EDW.DS_CUSTOMER_MASTER_20230529]