Looping through table to get values to pass to function

I have a table that contains a number of fields, three of which I'd like to pass to a pre-written function.  The table contains thousands of records but only 800 of those records fit the criteria I've applied to the three fields.  I'm very new to t-sql and am using MS Sql 2000.  I found some code on this that I've tried running in QA but it doesn't really return anything.  How can I loop through an existing table and then pass each result (each row consisting of the three fields) to a function and get a result back that I can then export to Excel?  

The code I'm attaching only pulls one field from the table since I'm just experimenting with how to do this.  I'd like to pull three fields and then call a function sending three variables, yearid, version and versioncode.  It does pull the correct number of rows according to the message that QA returns but I'm not getting any results

Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:

declare @tab Table (i int identity, YearID int)
declare @Rows int
Declare @YearId int
Insert into @tab
Select yearid 
From headertab
where yearid = 2009 
SELECT @Rows = @@ROWCOUNT
 
While @Rows > 0
Begin
select @YearId=YearID from @tab where i=@Rows
Set @Rows =@Rows - 1
end