USP_MODELINGANDPROPENSITYATTRIBUTE_ORIGIN_ADD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @ATTRIBUTECATEGORYID | uniqueidentifier | IN | |
| @ORIGIN | nvarchar(50) | IN |
Definition
Copy
create procedure dbo.USP_MODELINGANDPROPENSITYATTRIBUTE_ORIGIN_ADD
(
@CHANGEAGENTID uniqueidentifier = null,
@ATTRIBUTECATEGORYID uniqueidentifier,
@ORIGIN nvarchar(50)
)
as
begin
if not exists (select top 1 ID from dbo.MODELINGANDPROPENSITYATTRIBUTEORIGIN where ATTRIBUTECATEGORYID = @ATTRIBUTECATEGORYID)
begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
insert into dbo.MODELINGANDPROPENSITYATTRIBUTEORIGIN (ATTRIBUTECATEGORYID, ORIGIN, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
values (@ATTRIBUTECATEGORYID, @ORIGIN, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
end
end