Hi Tim;

  SQL Management Studio uses a native SS DB driver whereas ODBC is "Middle-ware" and might be the cause of the problem.

Have you tried connecting the PB IDE to SS using a native DB Client driver like SNC or better yet, the new MSOLEDBSQL driver?

Then try that SQL again n the DB Painter again.  HTH

Regards ... Chris

Thanks Chris.  We tried both SNC and MSOLEDBSQL it didn't make a difference 

Hi, Tim - 

In PB, are you running the SELECT statement in a DataWindow or are you running it in the ISQL pane in the Database Painter? If you're comparing results between SQL Server Management Studio (SSMS) and PB, the only meaningful comparison (in my opinion) would be running the SELECT in the ISQL pane/session.

Also, does the PB database connection use the same credentials (database login ID/pswd or Windows Authentication) as SMSS?

What compatibility level is the SQL Server database configured for? 150 (SQL Server 2019)?

As a test, if you encapsulate the SELECT statement in a stored procedure and execute the stored procedure in both SSMS and PB's Database Painter (ISQL), how different are the timings?

Can you post the SELECT statement being tested?

Best regards, John

Hi,

Here's anothe one:

When you say it takes "only" 2 / 3 seconds in Management Studio to retrieve 190 rows, is that SSMS running on the server or on your local PC?

regards.