Comments by Rohit Kesharwani (Top 1 by date)

As above we have mentioned our Stored Procedure structure, there are multiple select queries for different tables to fetch records.

If we use join then will it resolve our issues?

Please let me know your thoughts and suggestations.

Thanks,