Execute a stored procedure from within a query 2

[dddenney]

Is it possible to execute a store procedure from with in a query? Example of what I would like to do:

select emp_id, last_name, first_name,
(exec sp_Get_Overall_Incentive_Score @emp_id = em.emp_id) as score
from employee_master as em
where term = 0


Thanks in advance for the help,

Dan

 

[SQLDenis]

use a table valued user defined function insetead

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Nagrom]

From the looks of things what you really want to do is create a user defined function. You can create a UDF like this:

CREATE function dbo.getOverallScore (@emp_id int) returns int
as begin 

declare @Score int

select @Score = Avg(SingleScore) 
from MyScoreData (nolock)

return @Score

end

 

[dddenney]

Thank you!

I'm not sure why I didn't think of that in the first place.