USP_CONSTITUENT_CHECKINACTIVEANDDECEASED
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @INACTIVEERRORMESSAGE | nvarchar(100) | IN | |
| @DECEASEDERRORMESSAGE | nvarchar(100) | IN |
Definition
Copy
create procedure dbo.USP_CONSTITUENT_CHECKINACTIVEANDDECEASED
(
@ID uniqueidentifier,
@INACTIVEERRORMESSAGE nvarchar(100) = 'BBERR_CONSTITUENTISINACTIVE',
@DECEASEDERRORMESSAGE nvarchar(100) = 'BBERR_CONSTITUENTISDECEASED'
)
as
set nocount on;
if exists (select 1 from dbo.CONSTITUENT where ID = @ID and ISINACTIVE = 1)
raiserror(@INACTIVEERRORMESSAGE, 13, 1);
if exists (select 1 from dbo.DECEASEDCONSTITUENT where ID = @ID)
raiserror(@DECEASEDERRORMESSAGE, 13, 1);
return 0;