So sometimes I'll create a SQL Server Stored Procedure...sometimes I'll just write raw SQL in my Execute SQL Task.

Is there any general rule of thumb as to when to create a SQL Server Stored Procedure and when using raw SQL is alright when utilizing an Execute SQL Task? Would have it have anything to do with re-usability which would dictate a SQL Server Stored Procedure...is either one more efficient...

Thanks for your review and am hopeful for a reply.

• Changed type ArthurZMVP, Moderator 11 hours 39 minutes ago

Procedure, as its name implies, is for more than a single SQL statement.

I tend to use ad-hoc sql for simple miscellaneous things, but when performance, or business logic is an item to worry about I choose the Stored Procedure.

That's kind of what I thought and where I was on the subject.

Thanks Arthur!