USP_NAMINGOPPORTUNITYHANDLINGCODE_GETLIST

Returns the set of table entries for the "Naming Opportunity Special Handling" code table.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Input parameter indicating whether or not to include inactive code table entries in the list.

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  12/17/2008 2:33:45 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=1.7.1271.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_NAMINGOPPORTUNITYHANDLINGCODE_GETLIST(@INCLUDEINACTIVE bit)
AS
    if dbo.UFN_GETLISTSORTMETHOD('NAMINGOPPORTUNITYHANDLINGCODE') = 0
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE] from dbo.NAMINGOPPORTUNITYHANDLINGCODE where ACTIVE = 1 order by DESCRIPTION
            else
                select ID, DESCRIPTION, [SEQUENCE] from dbo.NAMINGOPPORTUNITYHANDLINGCODE order by DESCRIPTION    
            end
    else
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE] from dbo.NAMINGOPPORTUNITYHANDLINGCODE where ACTIVE = 1 order by SEQUENCE
            else
                select ID, DESCRIPTION, [SEQUENCE] from dbo.NAMINGOPPORTUNITYHANDLINGCODE order by SEQUENCE
            end