No... it only get's updated on INSERT... like any default, it WILL NOT BE APPLIED DURING UPDATES... for example...

USE TEMP

CREATE TABLE ModifyTest(SomeCol INT, ModifiedDate DATETIME)

GO

CREATE...

First, I think the use of global (##) temp tables, as you have, will eventually burn you with a "table already exists" error.  Recommend you change them to local (#) temp...

There are about a thousand posts about this on this forum.  Please do a search on "crosstab" and "pivot".

Ah... got it, David... thought you were talking about something else.

Thanks for the feedback, NorVid.

That would be Hawaii...

In the same vein, which state observes both Central Daylight Time AND Eastern Daylight Time?

Can you post what you used?  We can all learn a new trick or two....

Me, too... let us know what they say, Luk?

sp_lock

sp_who2

Find wherever sysinfo.exe is on the C: drive and execute it from a cmd window... more information will appear than you could possibly use including the number, make, model, revision,...

I'd likely make it use a few more CASE statements to keep from having to dip the Status table 3 times in the FROM clause... crosstab code is VERY fast if...

Heh... going back to the other posts, I see that now...

Hope things are going well for Mother and Child.

Can you post a line of the troublesome data?

Will a cursor fix it?