USP_ADDUPDATE_DONORINFORMATIONFIELDS

Parameters

Parameter	Parameter Type	Mode
@PKID	uniqueidentifier	INOUT
@CONTENTID	int	IN
@FIELDID	int	IN
@FIELDNAME	nvarchar(1024)	IN
@SEQUENCE	int	IN
@DISPLAYTEXT	nvarchar(1024)	IN
@ISINCLUDED	bit	IN
@ISREQUIRED	bit	IN
@ROWTYPECODE	tinyint	IN
@CODETABLEID	int	IN
Definition

Copy


    create procedure dbo.USP_ADDUPDATE_DONORINFORMATIONFIELDS
    (
            @PKID uniqueidentifier output,
            @CONTENTID int,
            @FIELDID int,
            @FIELDNAME nvarchar(1024),
            @SEQUENCE int,
            @DISPLAYTEXT nvarchar(1024),
            @ISINCLUDED bit = 0,
            @ISREQUIRED bit = 0,
            @ROWTYPECODE tinyint = null,
      @CODETABLEID int
    )
    as

    declare @CHANGEAGENTID UNIQUEIDENTIFIER;
    exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

    declare @DATE datetime
    set @DATE = Getdate()

    merge into DONORINFORMATIONFIELDS AS TARGET
    using (select @PKID as ID) AS SOURCE
    on(Source.ID = Target.ID)
    when MATCHED then 
    update set 
                             CONTENTID = @CONTENTID ,
                             FIELDID = @FIELDID,
                             FIELDNAME  = @FIELDNAME ,
                             SEQUENCE  = @SEQUENCE ,
                             DISPLAYTEXT = @DISPLAYTEXT,
                             ISINCLUDED  = @ISINCLUDED,
                             ISREQUIRED = @ISREQUIRED,
                             ROWTYPECODE = @ROWTYPECODE,
               CODETABLEID = @CODETABLEID,
                             DATECHANGED   = @DATE 
    when not matched by TARGET
    then insert (
                                             [ID],
                                             [CONTENTID],
                                             [FIELDID],
                                             [FIELDNAME],
                                             [SEQUENCE] ,
                                             [DISPLAYTEXT],
                                             [ISINCLUDED],
                                             [ISREQUIRED],
                                             [ROWTYPECODE],
                       [CODETABLEID],
                                             [ADDEDBYID],
                                             [CHANGEDBYID],
                                             [DATEADDED],
                                             [DATECHANGED]
                                )
                                values
                                (      
                                             @PKID,
                                             @CONTENTID ,
                                             @FIELDID,
                                             @FIELDNAME,
                                             @SEQUENCE,
                                             @DISPLAYTEXT,
                                             @ISINCLUDED,
                                             @ISREQUIRED,
                                             @ROWTYPECODE,
                       @CODETABLEID,
                                             @CHANGEAGENTID,
                                             @CHANGEAGENTID,
                                             @DATE,
                                             @DATE 
                                );