-- Give this a try as well

DECLARE @max_id int

DECLARE @i int

DECLARE @testTable TABLE (id INT)

SET @max_id = (SELECT MAX(ID) FROM Bill)

SET @i = 0

WHILE @i < @max_id

BEGIN

   INSERT INTO @testTable...

noeld,

I should of been clearer on what I'm am currently trying. I am using dynamic sql to create my search clause and in the query part where I select...

In assigning nulls, I'm referring to the query that will pass the data to the udf i.e. if you only needed 5 years worth of data calculated then,

SELECT id_1, id_2...