I think I'm kinda late here, but I want to know what if I have some SPs with different input parameters, how can I do that, I mean execute them at one time, also use a loop. thx
Though, this is a unique requirement but I would never suggest this architecture. This is quite bad approach and will lead down SQL Server performance. About your video: Nice work but one advice. Do not use EXEC.. it is a bad practice , instead use sp_executesql.
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
I enjoyed watching this video.
Thanks for educating the community
hi can you please explain for each container run the procedure parallel or one by one ? means if one procedure have error then other will not work.
Nice one. Thank you
kingingway Glad that you liked it:)
I think I'm kinda late here, but I want to know what if I have some SPs with different input parameters, how can I do that, I mean execute them at one time, also use a loop. thx
How about using conditional split based on procedure names then execute SQL task accordingly
Though, this is a unique requirement but I would never suggest this architecture. This is quite bad approach and will lead down SQL Server performance.
About your video: Nice work but one advice. Do not use EXEC.. it is a bad practice , instead use sp_executesql.
You are right. The purpose was to show how to loop through items n write expressions. Thanks for feedback
Just what to know if this is right: "EXEC"+ @[User::DatabaseName]+"."+ @[User::SchemaName]+"."+ @[User::SPName]