TMDM-7463: "Distinct operator is not supported on long text field on SQL Server"

Initial commit for bug fix.
Alternative implementation for service: don't use DISTINCT operator.
TMDM-7463: "Distinct operator is not supported on long text field on SQL Server"

Code clean up (typo in constants).
Missing NLS.