tempTable(ID int not null identity(1,1) primary Key, Col1 int, Col2 int, Col3 int)

create proc [dbo].[spGetData]
@Col1 int
@Col2 int
@Col3 int
as begin
declare @count int
declare @currentColumn varchar(25)
declare @currentColumnVal varchar(25)
set @count = 1
set @currentColumn = NULL
set @currentColumnVal = NULL
create #tempTable(ID int not null identity(1,1) primary Key, Val1 int, Val2 int, Val3 int)
insert #tempTable(Val1, Val2, Val3) Values(@Col1, @Col2, @Col3)
set @count = 1

while @count < 3
begin 
 set @currentColumn = 'Val' + CAST(@count AS VARCHAR(25))  
 select @currentColumnVal = @currentColumn from #tempTable
 -- Do stuff
 -- Do more Stuff
 set @count = @count + 1
end 

print @currentColumnVal -- Just to see what the value of the last Column is

end