Gibor 11223344
Today: 2025-10-02
|
|
A_SQLStat_AlertScore Gibor 11223344 |
|
|
Today: 2025-10-02
|
| SQLstat_A | IF EXISTS(select COUNT(*) OVER () as Total_Rows, dmria.*FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK)JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('')AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 ) SELECT COUNT(*) OVER () as Total_Rows, dmria.*FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('') AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 AND dmria. | |||
| inn_TaskRange | 1-4 | |||
| der_TaskRange | 1-4 | der_TaskString_1 | 1 AND 4 | |
| stateTaskRange | AlertScore BETWEEN 1 AND 4 | |||
| SQLstat_C | ORDER BY dmria.PushAlerts DESC, dmria.AlertScore DESC, dmria.TenantName asc ELSE SELECT 0 as Total_Rows | |||
| SQLstat_UN | IF EXISTS(select COUNT(*) OVER () as Total_Rows, dmria.*FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK)JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('')AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 ) SELECT COUNT(*) OVER () as Total_Rows, dmria.*FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('') AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 AND dmria.AlertScore BETWEEN 1 AND 4 ORDER BY dmria.PushAlerts DESC, dmria.AlertScore DESC, dmria.TenantName asc ELSE SELECT 0 as Total_Rows | |||