>Even shorter
>
>SELECT Max(DataInsertion)
>FROM Titre
I can't do it since it is part of a more complex query. I need to join tables based on the most recent data stored into an historical table.
>But, I think all these will be optimized and got the same. Look at the query plan for each.
Execution plans are different.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com