I need to pass a column number to an SP and get the value of that column from a cursor. Currently I have the following;

CREATE PROCEDURE AAA 
	@COLNUM smallint
AS

DECLARE @TESTFIELD varchar(100)
DECLARE @RESULT varchar(100)

set @TESTFIELD = COL_NAME(OBJECT_ID('Northwind.dbo.Employees'),@COLNUM )

DECLARE Employee_Cursor CURSOR FOR 
SELECT @TESTFIELD FROM Northwind.dbo.Employees

OPEN Employee_Cursor

FETCH NEXT FROM Employee_Cursor into @RESULT

PRINT @RESULT

CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
GO