table function

[huong30]

I had an existing function that return table value, which used to calculated the algorithm, work fine for individual input. However I had the need to run for the whole table...which I supposed I can do a while loop. I was wondering if there are other way to do this.

thx...


declare @id int
set @id=(select id from table where x=y)
select * from ufxFunction(@ID)

Want something similiar to this:

declare @id int,@Count int
set @count=(select count(*) from table)
set @id=1
while @id < @count
begin
insert into table2(x,y,z)
select x,y,z from ufxFunction(@ID)
@id=@id=1
end

 

[RiverGuy]

Hard to say without knowing your table/function structure, but can you create a new, similar function to operate on the entire table and join that to table1 to insert to table2?