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