I think I follow what you are saying and it makes sense. The scenario I was think of was a problem that I ran into while appending data to...

Sounds like great advice, I'll work on that over time. Am I guessing correctly that we can build working functional processes with loops etc in the SQL stored procedures...

Being very new I am basically building all my processes in the Query Designer and then pasting the SQL into stored procedures as it comes out of the designer. ...

So, that's cool, I can build another sp that will execute the others in the sequence I place them in? Excellent!

Thanks Todd, perhaps the problem I was running into was caused by other scheduled events firing at the same time. Regardless, I am now working in SQL with stored...

Thanks for your quick response. I am using SQL Server 2005 and utilizing the query designer to help generate the sql for actions I am placing into stored procedures.

For...