thanks..! i got it. I have another problem now.. how can we pass a perameter to call a function from a stored procedure.. please help

thanks, So I am trying to update my main temporery table by actually caluculating thr freight cost, So in this process i am trying to get the data in...

select @p = leg_id, @pall= pallets_amt, @su = lean_payable_amt from @TempIndividualFuel where rowid = @index

while @ind <= @TotalStops

begin

select @pa = leg_id,@pallet= pallets_amt, @sum = lean_payable_amt from...

I can provide all the data but this is too big to post on this forum so if you can provide me your email I will revert your email with...

I can provide all the data but this is too big to post on this forum so if you can provide me your email I will revert your email with...