The problem here is the scope in which the sql statement executes. The @temp table variable declared is different from the @temp variable used in the inline query as the scope of both the queries are different. To make the query work we need to run the query in same scope ie declare the table variable using the same SQL satements as one used for the query.
Please try to add some further information, perhaps we can understand then what you are trying to do.
Which database do you use - Oracle?
What is that "partition" - a partition of your hard disk, a "table space", ...?
What is the "scheme" - is that the wording used by Oracle?
And finally, what do you mean with "applied to my table"? Do you want to copy/move your table to that scheme?
Last Visit: 31-Dec-99 18:00 Last Update: 29-Sep-23 17:45