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

Oh no, no, no.... this is a lot easier than that... but I need you to post the CREATE statement for the table...

Heh-heh... My first inclination was to say "don't use text columns"   I won't even allow them into code at work because of...

Thanks Nick... I'm still curious though... why do you need to change the datatype of a column in a view?

I was leaning towards the previously suggested idea of some sort of permanent table for this and then I started thinking "spid" and then David stole my thunder