What's the purpose of Stored Procedure?
It will reduce the network traffic between client and server so that the number of calls between client and server are reduced. It's an performance issue.