fnFundRaiserGoal
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundRaiserID | int | IN |
Definition
Copy
create FUNCTION [dbo].[fnFundRaiserGoal](
@FundRaiserID int
)
RETURNS money
AS
BEGIN
RETURN (
SELECT
isnull(sum(solicitor.goal),0)
FROM
dbo.FundRaiserSolicitors Solicitor
WHERE
Solicitor.RootFundRaiserID = @FundRaiserID
)
END