USP_DATAFORMTEMPLATE_GETLIST

create procedure dbo.USP_DATAFORMTEMPLATE_GETLIST 

as

select DATAFORMTEMPLATECATALOG.ID, TEMPLATENAME, DATAFORMTEMPLATECATALOG.DESCRIPTION, COALESCE(RECORDTYPE.NAME, '') as 'RECORDTYPE', MODE
from dbo.DATAFORMTEMPLATECATALOG left outer join RECORDTYPE on DATAFORMTEMPLATECATALOG.RECORDTYPEID = RECORDTYPE.ID
order by TEMPLATENAME