Also another reason for nesting stored procs is to avoid potential recompilation.

Eg, you might have a stored proc with 5 lines of code that can often cause recompilation...

It is better to have SQL server recompile a 20 line "child" SP (which contains those 5 lines) then to have SQL server compile a single 100 line SP repeatedly.

I like the other reason in the article though - one point of call for very similar functions 🙂