[RESOLVED] Save SP Result to Parameter

[motil]

hi,

how do i save result to parameter when using SP?



i have something like this

SELECT SUM(price) 
FROM employee 
WHERE employee_id = @EmployeeID

the problem is that it sometimes return NULL, i want to save the result to parameter and check if this parameter is null if so i will return 0


something like that:

DECLARE @SumPrice decimal

SET @SumPrice = SELECT SUM(price) 
FROM employee 
WHERE employee_id = @EmployeeID IS NULL

i think i can do it like so...

IF SELECT SUM(price) 
FROM employee 
WHERE employee_id = @EmployeeID IS NULL
BEGIN

SELECT 0
END
ELSE
BEGIN
SELECT SUM(price) 
FROM employee 
WHERE employee_id = @EmployeeID IS NULL
END

but then i executing the query twice... (no good).... what is the best solution ?

thanks!

[GaryMazzone]

What about this:

SELECT ISNULL(SUM(price),0) As Summed 
FROM employee 
WHERE employee_id = @EmployeeID

[motil]

very nice, i never knew you can use isnull in such way.

Thanks!