Thread: create stored procedure from temporary table
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
Oops! dja.mnurdin@cma-cgm.com ("Nurdin") was seen spray-painting on a wall: > 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... Well, you can define a temporary table inside a stored procedure using EXECUTE, as long as all of the operations that touch that table are kept inside dynamic SQL invoked using EXECUTE... -- output = reverse("moc.liamg" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/oses.html "Bonus! The lack of multitasking is one of the most important reasons why DOS destroyed Unix in the marketplace." -- Scott Nudds