>I have a table with sales order number (sono), Transaction Code (tcode) and transaction date (tdate) fields.
>There are multiple records for one Sales Order.
>I want to write a query that returns one record with the sono, tcode and tdate for the latest date for that sales order and I have a complete blank
>HELP!!

Please see http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/including-an-aggregated-column-s-related for 6 different solutions of this problem.

You may also want to see http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/including-an-aggregated-column-s-related-2 that shows test cases for the problem.