I'm having trouble finding the latest timesheet through an SQL query. The prVersion column of prTimesheet is not reliable since not always does the latest timesheet have the higest version number. Also if I use prAdjustment column, there are timesheets that were never adjusted so they have pradjustment=0 but others who have been adjusted once have pradjustment=1
Please suggest. Thanks.