Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
import through SP |
Wed, May 9 2007 10:17 AM | Permanent Link |
"Harry de Boer" | LS
Is there a way to -in a strored procedure- import contents of a source table (different fields) to a target table? SourceTbl ============ Id_user INTEGER Id_Campagne VARCHAR(10) //does not need to be imported datum DATE van TIME tot TIME TargetTbl ========== UserID INTEGER //from Id_user vanaf TIMESTAMP //from datum+van totoenmet TIMESTAMP //from datum+tot An example -if it is possible at all- would be most appreciated. Regards, Harry |
Wed, May 9 2007 11:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
Why not just use INSERT INTO? Roy Lambert |
Wed, May 9 2007 5:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< Is there a way to -in a strored procedure- import contents of a source table (different fields) to a target table? >> Sure, as Roy said just EXECUTE IMMEDIATE an INSERT INTO statement that selects the desired columns from the other source table. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |