Stored Procedure to Rule them All

[Parariddle]

Hi All

I am looking to create a stored procedure to run multiple stored procedures.

I want the procedure to truncate all tables and upload files and loop where the date is between 2 dates then stop when the last file has been uploaded.

The other procedures are the upload and format procedures.

Hope this makes sense and hope you can help

Thanks

 

[SQL_Hell]

Ok...

So whats the question here exactly?

 

[oumahexi]

I think the question here is how to run a series of store procedures, like, using SQL Server Agent to create a job that will run them in sequence? Does that sound like what you want to do? Have you already created your stored procedures, tested them, and made sure they work?

 

[SQL_Hell]

Looks like the dark DBA of mordor, no longer requires any assistance

 

[oumahexi]

Perhaps the evil one crept up and slipped away with him/her???