![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
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 ![]() | 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. ![]() | 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 Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |