USP_DATAFORMTEMPLATE_VIEW_TODAYSMEMBERSHIPSALESUIWIDGET
The load procedure used by the view dataform template "Today's Membership Sales UI Widget View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @TOTALREVENUE | money | INOUT | Today's membership sales |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_TODAYSMEMBERSHIPSALESUIWIDGET
(
@DATALOADED bit = 0 output,
@TOTALREVENUE money = null output
)
as
set nocount on;
set @DATALOADED = 0;
select @DATALOADED = 1,
@TOTALREVENUE = dbo.UFN_MEMBERSHIP_GETTODAYSMEMBERSHIPREVENUE();
return 0;