SELECT * FROM [Scoring_WS].[dbo].[LogInOut] WITH (NOLOCK) WHERE OutXml.value('(/response/body/setVariablesMotor/varIntermedias/flagPromesaPlanSueldo)[1]', 'text') = '1' --(InXml like '%flagPromesaPlanSueldo>true%' OR InXml like '%flagPromesaPlanSueldo>1%') AND (Fec_Inicio BETWEEN '2023-02-01 00:00:00.000' AND GETDATE()) ORDER BY Fec_Inicio
## License This project is licensed under the MIT License - see the [LICENSE.md](LICENSE.md) file for details