USP_GETORADD_PHILANTHROPICGIFTCATEGORY

CREATE procedure dbo.USP_GETORADD_PHILANTHROPICGIFTCATEGORY(
                @ID uniqueidentifier = null output,
                @CATEGORY nvarchar(200) = null,
                @CHANGEAGENTID uniqueidentifier = null
                )
as
begin
        set @ID = null;

        select @ID = ID from dbo.PHILANTHROPICGIFTCATEGORY
            where @CATEGORY = DESCRIPTION

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

            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            insert into dbo.PHILANTHROPICGIFTCATEGORY (
                ID,
                DESCRIPTION,
                ADDEDBYID,
                CHANGEDBYID
            ) values (
                @ID,
                @CATEGORY,
                @CHANGEAGENTID,
                @CHANGEAGENTID                
            )
        end
end