USP_DATALIST_REGISTRATIONINFORMATIONSECTIONS

Parameters

Parameter Parameter Type Mode Description
@INCLUDEINACTIVE bit IN

Definition

Copy


CREATE procedure dbo.USP_DATALIST_REGISTRATIONINFORMATIONSECTIONS
(
    @INCLUDEINACTIVE bit = 0
)
as
    set nocount on;

    select 
        ID,
        DESCRIPTION, 
        ACTIVE
    from dbo.REGISTRATIONSECTIONCODE
    where @INCLUDEINACTIVE = 1 or ACTIVE = 1;