Advertisement

06.11.2008 at 10:51AM PDT, ID: 23476727 | Points: 100
[x]
Attachment Details

SQL Query (Return most current dates, per name)

Asked by kak39 in SQL Server 2005

Tags: ,

I need to return the most current dates, for a specifc values/nameStart Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

START:
 
NAME   UPDATE         VALUES
----   ------------   ------
MIKE   5/3/08 15:00     13
MIKE   6/1/08 12:00     15
MIKE   6/1/08 13:00     20
STEVE  5/2/08 12:00      3
STEVE  5/3/08 08:00      5
STEVE  6/8/08 13:00      7
HARRY  5/3/08 12:00     10
HARRY  5/2/08 13:00     11
HARRY  6/7/08 13:00     12
 
NEED QUERY TO RETURN THIS:
 
MIKE   6/1/08 13:00     20
STEVE  6/8/08 13:00      7
HARRY  6/7/08 13:00     12
[+][-]06.11.2008 at 10:54AM PDT, ID: 21762490

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2008 at 10:56AM PDT, ID: 21762505

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628