USP_MARITALSTATUSCODE_GETORCREATE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | |
| @DESC | nvarchar(100) | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_MARITALSTATUSCODE_GETORCREATE(
@ID uniqueidentifier output,
@DESC nvarchar(100),
@CHANGEAGENTID uniqueidentifier = null)
as
begin
select @ID = ID from dbo.MARITALSTATUSCODE where [DESCRIPTION] = @DESC;
if @ID is null
begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
exec dbo.USP_MARITALSTATUSCODE_CREATEENTRY @DESC, 1, default, @CHANGEAGENTID, @ID output;
end
end