How to Select from stored procedure in SQL?

We can't execute a Stored Procedure in a Select statement.You can use a User-defined function or a view instead of a procedure

 but you can copy output from Stored Procedure to temporary table as blow:

CREATE TABLE #Result

(

  Column_Name1 Nvarchar(50),  

  Column_Name2 Int

)

INSERT #Result exec Stored_Procedure_Name @Parameter1,@Parameter2

SELECT Sum(Column_Name2) as Total  FROM #Result

where "Condition Here"

DROP TABLE #Result