how to execute a SQL Stored procedure through SQL Worksheet in Designer

Hi,

I have an issue in which I want to execute a SQL query through Designer.
Can you please let me know how to do this?

Also I have one more issue in which I want to display the stored procedure result in MWS.

Can you please let me know the steps on how to do this…