Storing the result from a select statement into a variable

[DwayneL]

Hellp there
I need to know how to store the result of a select statment into a variable. Is this even possible?

Here is the code I'm trying to work with.

Declare @LastResNumber as varchar(8)

Set @LastResNumber = Select max(ReservationNum) from Booking

ReservationNum is also varchar(8)

 

[RobertT687]

Instead of SET, Use:
SELECT @LastResNumber = (SELECT MAX(ReservationNum)FROM Booking )

 

[imars]

dwaynel, try this
Select @LastResNumber = max(ReservationNum)
from Booking

 

[DwayneL]

Thanks guys, dang brackets, who would have thought