How to fetch all separated result in Stored Procedure with While Loop

I think you should try differently like to get all your records in a single table (SET based approach rather than While or cursor based.) and use that single table to populate in application layer.

Please write your logic to use Set based approach, whcih is good for performance of your system too.

---

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