Yes we can stored procedure call itself or recursive stored procedure. Because Stored procedures is basically are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. we can nest stored procedures and managed code references up to 32 levels. T-SQL supports recursion, we can write the stored procedures because of call, Recursion have a techniques or methods of problem solving, Where in the solution is applying o the problems it can be use of subset of problems only. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps.