All Forums Analytics
TDMGUSER 7 posts Joined 05/16
18 May 2016
stored proc to insert multiple tables into single table

Is there a way to insert records from multiple tables (20) into a single table using a macro or stored procedure. This is a recurring activity.
 
Thanks

yuvaevergreen 93 posts Joined 07/09
19 May 2016

Yes, you can use macro or stored procedure to insert. If its a simple insert statement, use macro (you need to invoke macro, everytime you insert). If it involves parameters and complex logic, go for stored procedure (you need to invoke macro, everytime you insert).

You must sign in to leave a comment.