caching sql data

Question

I am in a situation where i have to execute the stored procedure everytime with same parameters in the different functions. I want to cache the values when the sp executes first time and store the data, then i want to retrieve that cache value every time in my different functions. 

 

Is this possible? If yes then please help with any demo code.

Thanks!