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

Try this:

UPDATE t1

SET Diff = t2.Diff - t1.Est

FROM tmp_table AS t1

INNER JOIN tmp_table t2

ON t2.id = t1.id-1