Serqiy, my old friend... I'm all ears... there's code in the post to gen a million rows... can you show us how to get a similar report as the cross...

Thanks Mark,

I finally have enough information to help... with great zeal, I may add...

First, as Serqiy suggested, you don't need all those "generated" columns.  He suggested keeping one of them...

Of course there's some education in it, Ken... but, it's still forbidden because it hurts performance and a derived table should be used instead.  And, it will also catch these...

Crud... I didn't read the second query... sorry... not enough coffee...

To play on what David suggested... it's one of the reasons why I'm glad that the standards I wrote for...

It's because the Inserted table is only available in the current session... the dynamic SQL is actually a separate session with a different scope.  That's the whole reason why we...

That's strange... I'm thinking we have a service pack problem here... I'll bet you guys are running SP4 on SQL Server 2000... I'm running SP3A... and here's what I get...

Mark,

Thanks for posting the table schema...

Sorry to plague you with questions but trying to do this in a very simple fashion... I see that the TimeGenerated column is a DateTime...

I'm just about out of tricks on the Text columns, Charlotte... I'm still playing with it but haven't been able to come up with anything, yet.

Kind of where I was going with this but it's important, I think, to include the date columns in that so that you endup with a nice, whole datetime as...

Nope... that works too... I just thought I'd show another way.

I'm thinking that someone has done an update in a transaction with no commit from Query Analyzer... locks up the world sometimes.  Use sp_lock and sp_who2 to find out who's...

Concur with THAT!!

--===== Return user created tables only.  Ignores dtProperties, as well

 SELECT Name

   FROM dbo.SysObjects

  WHERE OBJECTPROPERTY(OBJECT_ID(Name),'IsMSShipped')=0

    AND XType = 'U'

'nuff said...