USP_DATAFORMTEMPLATE_EDIT_CONSTITUENCYCRITERIADONOR

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@DONORCONSTITUENCYDEFTYPECODE	smallint	IN
@DONORCONSTITUENCYDEFLASTYEARS	int	IN
@DONORCONSTITUENCYDEFSTARTDATE	datetime	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENCYCRITERIADONOR 
(
    @CHANGEAGENTID uniqueidentifier = null,
    @DONORCONSTITUENCYDEFTYPECODE smallint,
    @DONORCONSTITUENCYDEFLASTYEARS integer,
    @DONORCONSTITUENCYDEFSTARTDATE datetime
)
as

set nocount on;

begin try
    -- handle updating the data
    update dbo.INSTALLATIONINFO set
        DONORCONSTITUENCYDEFTYPECODE = @DONORCONSTITUENCYDEFTYPECODE,
        DONORCONSTITUENCYDEFLASTYEARS = @DONORCONSTITUENCYDEFLASTYEARS,
        DONORCONSTITUENCYDEFSTARTDATE = @DONORCONSTITUENCYDEFSTARTDATE
end try
begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0;