You've changed the basis a bit. It doesn't meet the original request anymore.

Am I understanding you correctly?

use northwind

select * from orders t1

where t1.orderdate=

   (select max(orderdate) from orders t2

    where t1.customerid=t2.customerid)

order by t1.customerid

select * from orders t1 inner join

(select customerid, max(orderdate) as...

Also you wouldn't get that error if you were using a stored proc

Can you explain this?

Sorry, but shouldn't you already have a copy of SQL Server 7?

You might be able to pick up some older book that contains...

It's not all that hard to guess, assume, know.. call it whatever you like, since you comment on each and everything currently.

Sounds like "good news" for the next version of SQL Server.

Use the TEXT datatype. Your front-end will have to do all the interpretation of such data.

Why did I know, that you would comment on this?

I would also go with the CONVERT. However, I would use CHAR(8) instead of VARCHAR(8).

However, the more interesting question is, why would you want...

Speaking of temporal data, you can also check out Richard Snodgrass' homepage. You can download his famous book on temporal data there for free. It's a must-read, to me anyway....

Yes, my understanding is, that every time a new table is created those two columns are automatically added. Looks like some kind of auditing information to me.

Not a direct solution, but I think you'll get the idea

use northwind

select

 sum(case when isnull(freight,0)=0 then 1 else 0 end) as 'ohne Fracht'

 , sum(case when isnull(freight,0)>0 and isnull(freight,0)<18 then 1 else...

Would you not use an IDENTITY int as a PK ?

That's a joke, right?

Please not again such a discussion. The fora here and the Google groups are full of...

Boy, you eat just one little baby and everyone thinks you are a monster!

Interesting new facette. I always thought you only stomp on the flower on your way.

Even more since you've entered...