USP_BBNC_CREATETRIBUTE

Creates a tribute for a downloaded Blackbaud Internet Solutions transaction.

Parameters

Parameter	Parameter Type	Mode
@TRIBUTEID	uniqueidentifier	INOUT
@TRIBUTETEXT	nvarchar(255)	IN
@TRIBUTETYPECODEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_CREATETRIBUTE
            (
                @TRIBUTEID uniqueidentifier output,
                @TRIBUTETEXT nvarchar(255),
                @TRIBUTETYPECODEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            set @TRIBUTEID = null;

            select 
                top 1 @TRIBUTEID = ID 
            from dbo.TRIBUTE 
            where TRIBUTETYPECODEID = @TRIBUTETYPECODEID
            and TRIBUTETEXT = @TRIBUTETEXT
            and TRIBUTEEID is null
            and ISACTIVE = 1 
            and DESIGNATIONID is null
            and NAMEFORMATFUNCTIONID is null
            order by DATEADDED desc

            if @TRIBUTEID is null
            begin
                set @TRIBUTEID = newid();

                insert into dbo.TRIBUTE(ID, TRIBUTETYPECODEID, TRIBUTETEXT, ISACTIVE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(@TRIBUTEID, @TRIBUTETYPECODEID, @TRIBUTETEXT, 1, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end