USP_BATCHTEMPLATE_GETIMPORTHANDLERS

CREATE procedure dbo.USP_BATCHTEMPLATE_GETIMPORTHANDLERS(
  @ID uniqueidentifier
)
as
begin
  select 
          0 as BATCHTEMPLATETYPE, --Batch

      BATCHTYPECATALOG.SPECXML 
  from 
      dbo.BATCHTEMPLATE
  inner join 
      dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
  where 
      BATCHTEMPLATE.ID = @ID
  union all
  select
    1 as BATCHTEMPLATETYPE, -- BatchExtension

    BATCHTYPEEXTENSIONCATALOG.SPECXML
  from 
    dbo.BATCHTEMPLATE
  inner join 
    dbo.BATCHTYPEEXTENSIONCATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPEEXTENSIONCATALOG.BATCHTYPECATALOGID
  where BATCHTEMPLATE.ID = @ID;
end