Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

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 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