USP_RESEARCHGROUPCATEGORYCODE_GETLIST

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:08:54 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_RESEARCHGROUPCATEGORYCODE_GETLIST(@INCLUDEINACTIVE bit, @APPUSERID uniqueidentifier = null)
AS

    if dbo.UFN_GETLISTSORTMETHOD('RESEARCHGROUPCATEGORYCODE') = 0
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.RESEARCHGROUPCATEGORYCODE where ACTIVE = 1  order by DESCRIPTION
            else
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.RESEARCHGROUPCATEGORYCODE  order by DESCRIPTION    
            end
    else
        begin
            if @INCLUDEINACTIVE = 0
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.RESEARCHGROUPCATEGORYCODE where ACTIVE = 1  order by SEQUENCE
            else
                select ID, DESCRIPTION, [SEQUENCE], ACTIVE from dbo.RESEARCHGROUPCATEGORYCODE  order by SEQUENCE
            end