Can we write a sub function or procedure inside another stored procedure - SQL Server -

I want to know whether SQL Server (2000/05/08) has the ability to write nested stored procedure, I Does this mean - Writing a sub-function / process inside any other method does not call another SP Phone

Why was I thinking about it- one of my SP has duplicated code and it is only this SP is specific to So if we have this nested SP facility then I can process the local process within the other sub / my main SPA and all repetitive lines in it and I can call that local SP in my main SP. I remember that such a facility is available in Oracle SP.

If this feature is also available in SQL Server, then someone will explain some more details about it or provide a link where I can get the document.

In advance thanks sai

It does not have that feature

In addition to stopping the code from nested SPROC from being called from other places, it is difficult to see what benefits would be like with this feature.