USP_IDMAPPER_GETLIST

create procedure dbo.USP_IDMAPPER_GETLIST
    @FilterSourceRecordType nvarchar(50) = '',
    @FilterTargetRecordType nvarchar(50) = ''
as
    select IDMAPPERCATALOG.ID, IDMAPPERCATALOG.NAME, IDMAPPERCATALOG.DESCRIPTION, 
           COALESCE(SOURCERECORDTYPE.NAME, '') as 'SOURCERECORDTYPE', COALESCE(TARGETRECORDTYPE.NAME, '') as 'TARGETRECORDTYPE'
    from dbo.IDMAPPERCATALOG
    left outer join dbo.RECORDTYPE as SOURCERECORDTYPE on IDMAPPERCATALOG.SOURCERECORDTYPEID = SOURCERECORDTYPE.ID
    left outer join dbo.RECORDTYPE as TARGETRECORDTYPE on IDMAPPERCATALOG.TARGETRECORDTYPEID = TARGETRECORDTYPE.ID
    where ((@FilterSourceRecordType = '') or (SOURCERECORDTYPE.NAME = @FilterSourceRecordType)) and
          ((@FilterTargetRecordType = '') or (TARGETRECORDTYPE.NAME = @FilterTargetRecordType))