Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
4.4 kB
5
Indexable
Never
exec sp_executesql N'[mrms].[lcr_Equation_NasabahPeroranganStabil_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'(LOG_SUM_END_SALDO_LSMK_START[MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START <= 2000000000SUM_SUM_END_SALDO_LSMK_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NasabahPeroranganTidakStabil_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'(( LOG_SUM_END_SALDO_LSMK_START [MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START > 2000000000SUM_SUM_END_SALDO_LSMK_END  ) OR [MASTERDPK_BSI].[IMBALAN] > case when inputLPS = ''IDR'' then 4.25 else 2.25 end )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NasabahUMKMStabil_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in(''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );(LOG_SUM_END_SALDO_LSMK_START[MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START <= 2000000000SUM_SUM_END_SALDO_LSMK_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_NasabahUMKMTidakStabil_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );(( LOG_SUM_END_SALDO_LSMK_START [MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START > 2000000000SUM_SUM_END_SALDO_LSMK_END  ) OR [MASTERDPK_BSI].[IMBALAN] > case when inputLPS = ''IDR'' then 4.25 else 2.25 end )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiOp_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(LOG_SUM_END_SALDO_LSMK_START[MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START <= 2000000000SUM_SUM_END_SALDO_LSMK_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiOp_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(( LOG_SUM_END_SALDO_LSMK_START [MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START > 2000000000SUM_SUM_END_SALDO_LSMK_END  ) OR [MASTERDPK_BSI].[IMBALAN] > case when inputLPS = ''IDR'' then 4.25 else 2.25 end )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiNonOp_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(LOG_SUM_END_SALDO_LSMK_START[MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START <= 2000000000SUM_SUM_END_SALDO_LSMK_END  )'
go
exec sp_executesql N'[mrms].[lcr_Equation_KorporasiNonOp_EOM] @p0,@p1 
',N'@p0 nvarchar(4000),@p1 nvarchar(4000)',@p0=N'20230428',@p1=N'([MASTERPEMBIAYAAN_BSI].[SUM_PENCAIRANPOKOK] <= 500000000 AND [EDW.CIF_DPK_DIVISI].[DIVISI_CD] in (''BBG'',''BB1G'',''BB2G'',''MBG'',''BBG_B_TO_B'',''BBG_B_TO_C'',''RDG'',''RDP'',''FHG'',''SMG'') );;(( LOG_SUM_END_SALDO_LSMK_START [MASTERDPK_BSI].[IMBALAN] <= case when inputLPS = ''IDR'' then 4.25 else 2.25 end AND LOG_SUM_END_SALDO_LSMK_END SUM_SUM_END_SALDO_LSMK_START > 2000000000SUM_SUM_END_SALDO_LSMK_END  ) OR [MASTERDPK_BSI].[IMBALAN] > case when inputLPS = ''IDR'' then 4.25 else 2.25 end )'
go
Leave a Comment