USP_DATAFORMTEMPLATE_VIEW_MARRIAGERULES

The load procedure used by the view dataform template "Global Marriage Rules View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SETMARITALSTATUS	bit	INOUT	Change marital status
@MARITALSTATUS	nvarchar(100)	INOUT	Marital status
@COPYPHONENUMBER	bit	INOUT
@COPYEMAILADDRESS	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MARRIAGERULES
(
  @DATALOADED bit = 0 output,
  @SETMARITALSTATUS bit = null output,
  @MARITALSTATUS nvarchar(100) = null output,
  @COPYPHONENUMBER bit = null output,
  @COPYEMAILADDRESS bit = null output
) 
as
  set nocount on;
  set @DATALOADED = 0;

  select top 1
    @SETMARITALSTATUS = UFN_MARRIAGERULE_GETRULES.SETMARITALSTATUS,
    @MARITALSTATUS = MARITALSTATUSCODE.DESCRIPTION,
    @COPYPHONENUMBER = UFN_MARRIAGERULE_GETRULES.COPYPHONENUMBER,
    @COPYEMAILADDRESS = UFN_MARRIAGERULE_GETRULES.COPYEMAILADDRESS,
    @DATALOADED = 1
  from
    dbo.UFN_MARRIAGERULE_GETRULES()
  left join
    dbo.MARITALSTATUSCODE on MARITALSTATUSCODE.ID = UFN_MARRIAGERULE_GETRULES.MARITALSTATUSCODEID

  return 0;