USP_DATALIST_SIGNATURE

create procedure dbo.USP_DATALIST_SIGNATURE
as
    set nocount on;

    select SIGNATURE.ID,
           dbo.UFN_SIGNATURE_USERNAME(SIGNATURE.SIGNERCODE, SIGNATURE.NAME, SIGNATURE.APPUSERID) as NAME,
       APPUSER.USERNAME as USERNAME,
       dbo.UFN_SIGNATURE_APPLICATIONSDESCRIPTION(SIGNATURE.ID) as APPLICATIONS
    from dbo.SIGNATURE
  left outer join dbo.APPUSER on APPUSER.ID = SIGNATURE.APPUSERID
  order by NAME