USP_DATAFORMTEMPLATE_VIEW_GROUPSALESPRICINGDEFAULT

The load procedure used by the view dataform template "Group Sales Payment Default View Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@USEFLATRATEPRICING	bit	INOUT	New reservations default to flat rate pricing
@GROUPSALESDEFAULTID	uniqueidentifier	INOUT	GROUPSALESDEFAULTID
@RATESCALESEXIST	bit	INOUT	RATESCALESEXIST

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GROUPSALESPRICINGDEFAULT
            (
                @DATALOADED bit = 0 output,
                @USEFLATRATEPRICING bit = null output,
                @GROUPSALESDEFAULTID uniqueidentifier = null output,
                @RATESCALESEXIST bit = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select top(1)
                    @DATALOADED = 1,
                    @USEFLATRATEPRICING = coalesce(USEFLATRATEPRICING,0),
                    @GROUPSALESDEFAULTID = ID,
                    @RATESCALESEXIST = isnull((select top(1) 1 from dbo.RATESCALE),0)
                from dbo.GROUPSALESDEFAULT

                return 0;