[thelist] Version Strategy (ASP)

[Edwin Martin]

Hi Rob Smith,

>What I want as a returned record set is
>
>ItemID  Item Name       Version
>7               ABC             4
>9               DEF             3
>6               GHI             2

Try this:

select max(itemid), itemname, max(version) from objects group by itemname

Where objects is the name of the table.

Edwin Martin



>I'm looking at different strategies for getting the last version of a
>collection of objects and am seeking your advice. Take:
>
>Item ID Item Name       Version
>1               ABC             1
>2               ABC             2
>3               ABC             3
>4               DEF             1
>5               GHI             1
>6               GHI             2
>7               ABC             4
>8               DEF             2
>9               DEF             3
>
>
>The straight forward approach would be to get a list of distinct projects:
>ABC, DEF, GHI. The traverse all items by each name and get the last version
>of each one. My initial thoughts lead me to a multidimensional array, but
>there HAS to be an easier way to do this. (After a long day of coding, I
>tend not to think straight anymore.)
>
>Is there some kind of query that'll do this for me in one move?
>
>Rob Smith
>--
>* * Please support the community that supports you.  * *
>http://evolt.org/help_support_evolt/
>
>For unsubscribe and other options, including the Tip Harvester
>and archives of thelist go to: http://lists.evolt.org
>Workers of the Web, evolt !
--
Surf Edwin Martin's brainwaves: http://www.bitstorm.org/edwin/