The difference in results between Denodo Platform and MS SQL server could be due to many factors. To find the cause of it I would check the execution trace of the query available in the Virtual DataPort Administration tool, which provides information on the operations carried out by the Denodo query engine. This may include details of applied implicit functions, optimization technique, query delegated to the MS SQL server data source, etc. Refer to the section [Execution Trace of a Statement]( https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement#execution-trace-of-a-statement) for more information.
Hope this helps!