USP_DATALIST_CONSTITUENTINACTIVITYREASONCODES
Returns a list of reason codes.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INCLUDEINACTIVE | bit | IN | Include inactive |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CONSTITUENTINACTIVITYREASONCODES
(
@INCLUDEINACTIVE bit = 0
)
as
set nocount on
select
ID,
CODE,
DESCRIPTION,
ACTIVE
from dbo.CONSTITUENTINACTIVITYREASONCODE
where
(ACTIVE = 1 or @INCLUDEINACTIVE = 1)
order by CODE asc