USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENCYCRITERIADONOR

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@DONORCONSTITUENCYDEFTYPECODE	smallint	INOUT
@DONORCONSTITUENCYDEFLASTYEARS	int	INOUT
@DONORCONSTITUENCYDEFSTARTDATE	datetime	INOUT
@LOYALDONORCONSTITUENCYDEFPERIOD	int	INOUT
@LOYALDONORCONSTITUENCYDEFPERIODUNITCODE	smallint	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENCYCRITERIADONOR
(
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @DONORCONSTITUENCYDEFTYPECODE smallint = null output,
    @DONORCONSTITUENCYDEFLASTYEARS integer = null output,
    @DONORCONSTITUENCYDEFSTARTDATE datetime = null output,
    @LOYALDONORCONSTITUENCYDEFPERIOD integer = null output,
    @LOYALDONORCONSTITUENCYDEFPERIODUNITCODE smallint = null output
)
as

set nocount on;

set @DATALOADED = 0
set @TSLONG = 0

select
    @DATALOADED = 1,
    @TSLONG = CONSTITUENCYCRITERIASPOUSE.TSLONG,
    @DONORCONSTITUENCYDEFTYPECODE = INSTALLATIONINFO.DONORCONSTITUENCYDEFTYPECODE,
    @DONORCONSTITUENCYDEFLASTYEARS = INSTALLATIONINFO.DONORCONSTITUENCYDEFLASTYEARS,
    @DONORCONSTITUENCYDEFSTARTDATE = INSTALLATIONINFO.DONORCONSTITUENCYDEFSTARTDATE,
    @LOYALDONORCONSTITUENCYDEFPERIOD = CONSTITUENCYCRITERIASPOUSE.LOYALDONORCONSTITUENCYDEFPERIOD,
    @LOYALDONORCONSTITUENCYDEFPERIODUNITCODE = CONSTITUENCYCRITERIASPOUSE.LOYALDONORCONSTITUENCYDEFPERIODUNITCODE
from
    dbo.INSTALLATIONINFO
    outer apply dbo.CONSTITUENCYCRITERIASPOUSE

return 0;