Tag: progress-db

Limiting SQL query to 10,000 results by where clause only, by string field

I have an interesting issue that I’m struggling to solve. I am retrieving data from a DB via a web API. I have direct DB access for testing, but my application will need to read the data via the API. In the API I can essentially provide the where clause for the SQL statement that retrieves my data from the

How to transform one SQL column into multiple columns on the same row?

case-when openedge progress-db sql

I am working in a Progress ODBC in Excel and I have a data set that currently holds an ID, Object type and the result for that object. The dataset looks a little like below: EveNumber …