Let we have script that consists of 3 procedure calls:
mydb.myschema.PopulateDimensions(...)
mydb.myschema.PopulateFactTable(...)
mydb.myschema.UpdateStatistics(...)
Will they be executed in the same order or they will be inlined into the script and the entire mix will be executed in parallel?
They will be inlined and then the compiler, optimizer and scheduler will determine how to best execute the overall script.
What are you trying to achieve/hope for?