Stored Procedure Help Please

[LobsterSte]

Hallo.

I am bussy with a project that is due in a weeks time. I am using vb. Net 2003 to connect to sql, but a problem have come up which I do not have a solution for.

I need to create a stored procudure that gives me the ability to get the last record in the tabel.

Table name: tblRent
Fields: intID, intCID, intDVDID, dtRent, dtReturn

I need to know the last intID in the record.

Please help me!

 

[SQLDenis]

Lookup MAX and TOP in BOL

MAX(intID)

TOP 1..ORDER BY intID DESC

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[LobsterSte]

Sorry Dude, I am still new to this whole SQL story.

Thanx a Million!

If I had one wish I would wish I could Understand SQL as good as you guys!