DECLARE @MYVAR NVARCHAR(100)

DECLARE MYTESTCURSOR CURSOR

DYNAMIC

FOR

SELECT [name] FROM latest_value

OPEN MYTESTCURSOR

FETCH LAST FROM MYTESTCURSOR INTO @MYVAR

CLOSE MYTESTCURSOR

DEALLOCATE MYTESTCURSOR

SELECT @MYVAR