Selected the newest record

[jcg6]

How can I use a stored procedure to select a record that was just added to a table? I want the most recently added record...

I'm sure that there is an easy way to do this, but I am new to this and can't seem to find a solution. Any help would be appreciated. Thanks very much!

 

[dbomrrsm]

Create PROC LASTRECORD
AS

SELECT FIELD1,FIELD2,TIME etc
FROM MYTABLE
WHERE TIME = (SELECT MAX(TIME)FROM MYTABLE)

 

[jcg6]

Thank you for your quick response. That was exactly what I needed to know!! [SMILE]