[thelist] Version Strategy (ASP)

[Joshua Olson]

----- Original Message ----- 
From: "Edwin Martin" <edwin at bitstorm.org>
Sent: Wednesday, January 07, 2004 2:59 PM


> Try this:
>
> select max(itemid), itemname, max(version) from objects group by itemname

Rob,

Edwin's version will work so long as the following is true:

For any given record, another record of the same itemname with a higher
version will also have a higher itemid.

If the above is not true, then the query will not work in the long run.

Just a heads up.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/FL/
706.210.0168