UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL
Provide household raised total in a given FAF event
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @HOUSEHOLDID | uniqueidentifier | IN | |
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL](
@HOUSEHOLDID as uniqueidentifier
,@EVENTID as uniqueidentifier
)
returns money
with execute as caller
as
begin
return (select AMOUNTRAISED from dbo.UFN_FAF_GROUPTOTALSROLLUP(@EVENTID, @HOUSEHOLDID));
end