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

Now we just need somebody to say SQL is nothing like COBOL...:-D

Conor Cunningham has a nice blog post on Runtime Constants:

http://blogs.msdn.com/b/conor_cunningham_msft/archive/2010/04/23/conor-vs-runtime-constant-functions.aspx

Last run date is by definition the date the report runs, AKA GETDATE().

Can you post the actual execution plan?

You may also take a look at this article on how to post performace problems:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sorry for the delay...

Thanks Jason, Bob and Paul!

I don't want to look like you-know-who, but you really have to fix your design.

Try putting the ethnicity column in a separate 0-N table. This is what the UNPIVOT does...

I did not understand the mixed ethnicity part, but I think you can work on something like this:

DECLARE @Ethnicity TABLE (

[PersonID] INT NULL,

[ETH_CAUCASIAN] [varchar](10) NULL,

[ETH_AFRAMER] [varchar](10) NULL,

[ETH_HISP] [varchar](10) NULL,

[ETH_NATIVEAMER] [varchar](10)...

Have you tried with UNPIVOT?

Can you post table scripts and some sample data?

:hehe: It was the only part I was not happy with. :hehe::-D

Surprisingly, it was...

Yes, that's my post!

I couldn't load Grant's blog today, it seemed to be down, but now it loads and also I got a mail from him.

I can't believe it!

Did I??? Great!!!!!

Thank you Red-Gate, Grant and Steve!!!

Where did you see this, Roy?

This looks more like the title of a book rather than a question.

Doesn't BOL cover the topic with enough detail?

SQLkiwi (12/18/2010)

---

My first impressions of SQLcomplete are that it is quite usable, and annoying in different ways from standard IntelliSense.

It's a very new product, and will no doubt be much...

Craig Farrell (12/17/2010)

---

I actually feel a bit bad for you, Gianluca. That's my daily feeling when I log in here. 🙂 I've become inured to the feeling and...