troubleshooting Question

SQL Syntx for getting the latest record in a table

Avatar of ISBTECH
ISBTECHFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
9 Comments2 Solutions374 ViewsLast Modified:
I have a table that logs activities with a transfer of data to a third party company, there are multiple transfers of data per sale as the process of finalizing the sale proceeds.  The table tracks the individual sale through a unique SalesID and then records each transfer of data via a sequence number and an action code.  So the first transfer of data for a particular sale would be sequence number 1 and say action code 1, then later in the process we transfer again and I would then see sequence number 2 and action number 102, then later there may be up to two additional transactions sequenced as 3 and 4 with action codes of 299, 205 etc.  I need to be able to pull data from this table for transactions that have reached action code 102 but no further in the process.  I know there is a MAX command that takes the biggest number in a table but I'm unsure how to use it in this case.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros