Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedure

Author  Topic 

jcb267
Constraint Violating Yak Guru

291 Posts

Posted - 2014-09-19 : 13:48:24
Hi -

I have been using SQL for about 3 years now but never really used stored procedures. I started doing a client reporting package four months ago, it will be run every month when our data warehouse refresh is complete.

Currently, I have 5 queries to accomplish this. The queries are executed and save the output to a table for archiving purposes. Can I string all five queries together in one stored procedure and save results as needed?

Any suggestions??

Thanks!
John
   

- Advertisement -