is there any harm in calling stored procedure recusivlly.

I would say, RECURSION itself a BAD idea. You may need to avoid recursive method and move towards a SET BASED approach whenever possible. You can use Temp table/Table variable effectively to avoid the recursive calls.

Could you please explain what are you trying to accomplish, may be we would be able to help you if you could provide some sample data and your desired output.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.