I think you should try to filter as much as possible the input with an appropriate index, and then join the correlated table.

Given that usually the primary key is the...

It depends on what you want to set up. I suppose you want to play with the database, so you'd better install the database server.

Which OS are you installing to?

SQLkiwi (12/21/2010)

Gianluca Sartori (12/21/2010)

... if you like Nested Loops! 😛

It's a great feature, but it often ends up with a Nested...

???

You could extract the data in your report from a stored procedure, that could update some table with a "last run date" field.

Even better, without changing the report data source,...

I bought this book from Amazon and I found it very useful:

http://www.amazon.com/gp/product/0470395141/ref=oss_product

Hope...

Oracle documentation library is the best place to start from:

http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

You can find a detailed installation guide, both PDF and HTML.

Glad you sorted out.

Well done, Paul!

Without a query plan to look at, I would end up with a useless suggestion.

I'm sure you can live without it.

This is how you could do it with a "quirky update".

The technique is described in detail here[/url].

IF OBJECT_ID('tempdb..#tmp_table') IS NOT NULL DROP TABLE #tmp_table

;WITH SampleData (ID, Inv, Est, Diff)

AS (

...

You're trying to do a running total. Give me a couple of minutes...

Let's work on the sample data you provided:

IF OBJECT_ID('tempdb..#tmp_table') IS NOT NULL DROP TABLE #tmp_table

;WITH SampleData (ID, Inv, Est, Diff)

AS (

...

... if you like Nested Loops! 😛

It's a great feature, but it often ends up with a Nested Loops implementation. It's...

SQLkiwi (12/21/2010)

Assuming you want to update all rows, not just the one...