Temporary Table Allocation
From: Peter Secor <seco5001_at_quean.cims.nyu.edu>
Date: 1998/01/09
Message-ID: <696b4t$4of$1_at_news.nyu.edu>#1/1
Date: 1998/01/09
Message-ID: <696b4t$4of$1_at_news.nyu.edu>#1/1
Hello All,
Thanks,
Peter
Does anyone have a good reference regarding temporary table allocation
during a stored procedure call? I am looking to store the results of a
subquery in a temporary table that I wish to exist only for the life
of the surrounding query. So far I have declared tables before the
subquery, but these do not seem to be of the correct format (I recieve
type mismatch errors though the types I am using seem to be the same).