USP_DATAFORMTEMPLATE_ADD_RATESCALE_PRELOAD

The load procedure used by the edit dataform template "Rate Scale Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ISDEFAULT	bit	INOUT	Set as default rate scale

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RATESCALE_PRELOAD
(
    @ISDEFAULT bit = null output
)
as
    set nocount on;

    if not exists(select 1 from dbo.RATESCALE where ISDEFAULT = 1)
        set @ISDEFAULT = 1
    else
        set @ISDEFAULT = 0

    return 0;