USP_SIMPLEDATALIST_IMPORTFILETEMPLATES

create procedure dbo.USP_SIMPLEDATALIST_IMPORTFILETEMPLATES
(
  @BATCHTEMPLATEID uniqueidentifier
)
as
    select 
        ID as VALUE, 
        NAME + ' (delimited file)' as LABEL
    from 
    dbo.IMPORTFILETEMPLATE
  where
    IMPORTFILETEMPLATE.BATCHTEMPLATEID = @BATCHTEMPLATEID
  union
  select 
        ID as VALUE, 
        NAME + ' (fixed-width file)' as LABEL
    from 
    dbo.IMPORTFIXEDWIDTHFILETEMPLATE
  where
    IMPORTFIXEDWIDTHFILETEMPLATE.BATCHTEMPLATEID = @BATCHTEMPLATEID
    order by 2