SQL Advice

[NewsBot]

I have some data that looks like this, ordered by date desc.

 

Date*******************************Card #***********Location

2007-06-28 16:32:12****966613554****Server Room

2007-06-05 12:25:06****966614310****Main Stores (Back Door)

2007-06-05 12:25:05****966614310****Main Stores (Back Door)

2007-06-05 12:25:04****966614310****Main Stores (Back Door)

2007-06-05 12:25:03****966614310****Main Stores (Back Door)

2007-06-05 12:25:03****966614310****Main Stores (Back Door)

2007-06-04 12:43:47****966613554****Server Room

2007-06-04 12:43:30****966613552****Server Room

2007-06-04 12:43:14****966613553****Server Room

2007-06-04 12:42:02****966613554****Server Room

2007-05-21 10:18:42****966613563****Alans Reader

2007-05-21 10:18:42****966613563****Alans Reader

2007-05-21 10:18:15****966613563****Alans Reader

2007-05-21 10:17:25****966613564****Alans Reader

2007-05-21 10:12:01****966613564****Alans Reader

 

And need to select the data in red.**The rules are I should only ever have one row for each card number and*the row slected should be the most recent use of that card.*

 

I've been toying with this for a while and still can't get it to work, anyone got any bright ideas?

 

Thanks

 

Stephen

 

More...

 

View All Our Microsoft Related Feeds