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