Recent content by sventevit

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

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 :)

Yes it does... more here: http://stackoverflow.com/questions/3577102/sql-2005-linked-server-to-oracle-queries-extremely-slow/3821718#3821718 It is better to use OPENQUERY in this example.

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...

OK, thanks for answers :)

Sorry for my late response... I think I need SQL statement, so I can execute it in WinSQL client and also in Visual Studio to populate some datasets. What is ABL? :confused: Cringer, your syntax is totaly new to me, have to look it up yet...

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...