[MSSQL] Run Procedure With Select

To run stored procedure using select, but the parameter is compulsory.

SELECT PROCEDURE_NAME(PARAM1,PARAMx)