When I add the 'DISTINCT' word to the SQL I get this error:
---------------------------
AspRunnerPro
---------------------------
Cannot retrieve columns information. Please modify SQL query and try again.
Error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DISTINCT'.
---------------------------
OK
---------------------------
The problem is that ASPRunner adds "top 20" before 'DISTINCT' instead of after.
Thanks