Inside a store procedure, I want to call another SP several times and insert the result into a table, is that possilbe? If so, how should I do that?
Thanks,
1. create a table SOURCE with 5 Varchar columns (F1,F2,F3,F4,F4 with length at least 30)
2. load your text file to the new created table, please use "MODIFIED BY COLDEL," only, no character delimiter
3. create table A (4 columns), B (2 columns), C (4 columns)
4. do three INSERT by selecting the...
Those select statements don't have the same number of records. For example, the first select only retruns a lable and the number of recrods; the second one is the real data extract. Is it possible to concatenate them together and export to one flat file?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.