0 THEN 1 ELSE 0 END) AS MOVIL_CTS,
SUM(AgoMovil) AS MOVIL_MONTO
FROM VT8002_Movil_IngresosPorClientePorMes";
break;
case '09':$sql = "SELECT
SUM(CASE WHEN SepMovil > 0 THEN 1 ELSE 0 END) AS MOVIL_CTS,
SUM(SepMovil) AS MOVIL_MONTO
FROM VT8002_Movil_IngresosPorClientePorMes";
break;
default: $sql = "SELECT
SUM(CASE WHEN AgoMovil > 0 THEN 1 ELSE 0 END) AS MOVIL_CTS,
SUM(AgoMovil) AS MOVIL_MONTO
FROM VT8002_Movil_IngresosPorClientePorMes";
break;
}
} else {
$sql = "SELECT
SUM(CASE WHEN AgoMovil > 0 THEN 1 ELSE 0 END) AS MOVIL_CTS,
SUM(AgoMovil) AS MOVIL_MONTO
FROM VT8002_Movil_IngresosPorClientePorMes";
}
//Ejecutar Query
$result = sqlsrv_query($movil, $sql);
?>
| Empleados |
Clientes |
".
//"Total | ".
"15 | ".
"".$row['MOVIL_CTS']." | ".
//"".$total_porcent." % | ".
"";
sqlsrv_free_stmt($result);
sqlsrv_close($con_comercial);
?>