如何使用SQL Server将存储过程的结果存储在变量中

I am working on a SQL query where I have to store result of a stored procedure into a string type variable. There is a stored procedure named I am working on a SQL query where I have to sto