USP_BUSINESSPROCESS_GETLIST

            create procedure dbo.USP_BUSINESSPROCESS_GETLIST
                @FilterRecordType nvarchar(50) = ''
            as
                set nocount on;

                select 
                    BUSINESSPROCESSCATALOG.ID, BUSINESSPROCESSCATALOG.NAME, BUSINESSPROCESSCATALOG.DESCRIPTION, COALESCE(RECORDTYPE.NAME, '') as 'RECORDTYPE'
                from 
                    dbo.BUSINESSPROCESSCATALOG
                    left outer join dbo.RECORDTYPE on BUSINESSPROCESSCATALOG.RECORDTYPEID = RECORDTYPE.ID
                where 
                    ((@FilterRecordType = '') or (RECORDTYPE.NAME = @FilterRecordType))