[SQL] create stored procedure from temporary table

[Nurdin]

i was wondering, how to create dynamic table like temporary table but create from function and the result from function too....cos i want count same calculation from other table migh be a multiple table so i need looping and join table...   thnax   nurdin