what would be the correct syntax for calling a stored procedure within a select statement
example:

select set @ctr = @ctr + 1,
(exec dbo.mySP1 @ctr, empfl.empid) 
from empfl