Search results

  1. S

    (+) in the query

    Hello again :) What is the meaning of '(+)' operator in the query, like: WHERE ... (("Table1"."Param1"="Table2"."Param1" (+)) AND ("Table1"."Param2"="Table2"."Param2" (+))) AND ...
  2. S

    Order of where conditions

    Does the order of where conditions influence the execution of the query? Does it depend on indexes on the table (like in SQL Server)? Can you point me to some documentation? Thanks :)
  3. S

    SQL Server to Progress via Linked Server question

    What happens, if I execute the following query in SQL Server? select Col1, Col2, sum(Col3) as Col3Sum from LinkedServerName.Catalog1.PUB.Table1 where Col1 in (select Col1 from AnotherTableInSQLServer) group by Col1, Col2 Does SQL Server retrieve all records from Progress and then executes the...
  4. S

    Temporary tables

    I am new to Progress DB (used to work with SQL Server). In SQL Server there is a neat feature for preparing subselects ('with' keyword). How can I write this query in Progress: WITH ProductAndCategoryNamesOverTenDollars (ProductName, CategoryName, UnitPrice) AS ( SELECT p.ProductName...
Back
Top