I have 2 distinct SQL calls from differing data sources that give me similar results that ultimately need to reside in 1 table that needs to be updated on a daily basis.
I have't ever used stored procedures before since I've relied on Views but folks indicate that views can be slow & also have been told I can't do a union on a view.
Thus I have no idea how to do this & am looking for syntax help
Step 1 is to drop the table from the previous day
Step 2 is to create the table
Step 3 is to insert the data from the views into this recreated table.
How does one accomplish this & is a stored procedure the proper method to do it or is there a better way to accomplish my end goal.
Thanks a ton
- Gina
I have't ever used stored procedures before since I've relied on Views but folks indicate that views can be slow & also have been told I can't do a union on a view.
Thus I have no idea how to do this & am looking for syntax help
Step 1 is to drop the table from the previous day
Step 2 is to create the table
Step 3 is to insert the data from the views into this recreated table.
How does one accomplish this & is a stored procedure the proper method to do it or is there a better way to accomplish my end goal.
Thanks a ton
- Gina