Skip to Content
Sep 05, 2018 at 05:09 AM

BODS 4.2 - Table Comparison Sorted Input Option - Collation Statement in Order by Clause


In the Table Comparison Transform when I choose the Sorted Input option it places this in the Order by Clause after the first column: "COLLATE Latin1_General_BIN". I get spurious results in the result set with this occurring. If I change the option to Row by Row Select the order by clause does not produce the COLLATE statement in the order by clause and the results of the transform are as expected. What would cause this type of behavior in the Table Comparison Transform?