Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drman
Starting Member
38 Posts |
 Posted - 2003-12-02 : 11:33:10
|
I have a field in one of my tables that contains the Datetime each record was updated. I need to query this info to determine the datetime of the most recent updated record. There must be a better way other than creating a recordset indexed on lastupdated and reading the value from the field.Any Help would be greatly appreciated..just poing me in the right direction.thanks DRMAN |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-12-02 : 11:44:21
|
| How about using MAX() function?--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
drman
Starting Member
38 Posts |
Posted - 2003-12-02 : 12:03:43
|
| Never used the Max function, but it works great. Don't I feel stupid.Thanks alot.DRMAN |
|
|
|
|
|
|
Finding Most Recent Update