stored proc to insert multiple tables into single table

Analytics

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

1 REPLY

Re: stored proc to insert multiple tables into single table

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