Posted by patelk23 on 12/08/06 09:53

Hi everyone,
I am really struggling to do the following in sql. Your expertise will
be very welcome.

I have a table [TestData] below


IndexId IndexVersion LastAmendedWhen
---------- --------------- -------------------
29 1 06/10/2006 17:40:43
29 2 06/10/2006 17:41:29
29 3 09/10/2006 12:19:33
29 4 09/10/2006 12:20:03
29 5 10/10/2006 10:53:32

I want to pick out rows with the lastAmendedWhen for each dates. So my
output should look like
IndexId IndexVersion LastAmendedWhen
---------- --------------- -------------------
29 2 06/10/2006 17:41:29
29 4 09/10/2006 12:20:03
29 5 10/10/2006 10:53:32

Please can someone help. I am really struggling with this.

• Next in forum: Re: Searching for Last DateTime
• Prev in forum: Re: SQL 2000 Bulk Insert attempt on FTP in progress
• Thread view: Searching for Last DateTime

[Reply to this message]