Retrieving the Latest Record Without Row_Number() in SQL Server 2000

Converting String Columns to Datetime Variables in SQL Server: A Step-by-Step Guide to Retrieving Last 24 Hour Job Record