Hi Brian.
Minor update. As Sybase doesn't support LIMIT/OFFSET like structure (same
thing as for MSSQL) we use a method called "pivoting" (one column is used
as a "pivot" for retrieving other column values) for deriving row content
from tables. Now, problem is that pivoting requires "derived" tabl
Hi Brian.
Sorry for the late reply.
You can try it yourself and report back. You can go to the xml/queries.xml,
line 533 and change:
...count2="SELECT COUNT(*) FROM (SELECT DISTINCT %s FROM %s) AS
value_table"/>
to:
...count2="SELECT COUNT(DISTINCT %s) FROM %s"/>
Please, also try with multiple c