USP_IMPORTPROCESS_GETBYID

CREATE procedure dbo.USP_IMPORTPROCESS_GETBYID
(
  @ID uniqueidentifier
)
with execute as caller
as
  set nocount on;

  select 
    IMPORTPROCESS.BATCHTEMPLATEID,
    IMPORTPROCESS.NAME,
    IMPORTPROCESS.DESCRIPTION,
    IMPORTPROCESS.FILENAME,
    IMPORTPROCESS.COLUMNMAP,
    IMPORTPROCESS.DATEFORMAT,
    IMPORTPROCESS.FUZZYDATEFORMAT,
    IMPORTPROCESS.MONTHDAYFORMAT,
    IMPORTPROCESS.CODETABLEUSEID,
    IMPORTPROCESS.SIMPLEDATALISTUSEID,
    IMPORTPROCESS.USEDEFAULTVALUEWHENBLANK,
    IMPORTPROCESS.BATCHAPPUSERID,
    IMPORTPROCESS.SEARCHLISTUSEQUICKFIND,
    IMPORTPROCESS.ADDNEWCODETABLEENTRIES,
    IMPORTPROCESS.TREATFIRSTROWASHEADER, 
    BUSINESSPROCESSINSTANCE.SITEID,
    IMPORTPROCESS.BATCHCOMMITOPTIONCODE,
    IMPORTPROCESS.AUTOMATCHTHRESHOLD,
    IMPORTPROCESS.OVERALLMATCHTHRESHOLD,
    IMPORTPROCESS.PARAMETERSXML,
    IMPORTPROCESS.IMPORTSOURCEID,
    IMPORTPROCESS.SUBDIRECTORY,
    IMPORTPROCESS.CHECKFORDUPLICATES,
    IMPORTPROCESS.USEWILDCARDS,
    IMPORTPROCESS.TEMPFILENAME,
    IMPORTPROCESS.DELIMITEDFILETEMPLATEID,
    IMPORTFILETEMPLATE.DETAILCOLUMNMAP as DELIMITEDCOLUMNMAP,
    IMPORTPROCESS.FIXEDWIDTHFILETEMPLATEID,        
    IMPORTFIXEDWIDTHFILETEMPLATE.DETAILCOLUMNMAP as FIXEDWIDTHCOLUMNMAP,
    isnull(IMPORTPROCESS.DELIMITER,',') as DELIMITER,
    BATCHTEMPLATE.NAME BATCHTEMPLATENAME,
    IMPORTPROCESS.USEBATCHTEMPLATEMATCHSETTINGS,
    IMPORTPROCESS.TSLONG
  from 
    dbo.IMPORTPROCESS
    inner join BATCHTEMPLATE 
      on BATCHTEMPLATE.ID = IMPORTPROCESS.BATCHTEMPLATEID 
    left join dbo.BUSINESSPROCESSINSTANCE 
      on BUSINESSPROCESSINSTANCE.BUSINESSPROCESSPARAMETERSETID = IMPORTPROCESS.ID
    left join dbo.IMPORTFILETEMPLATE 
      on IMPORTFILETEMPLATE.ID = IMPORTPROCESS.DELIMITEDFILETEMPLATEID
    left join dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
      on IMPORTFIXEDWIDTHFILETEMPLATE.ID = IMPORTPROCESS.FIXEDWIDTHFILETEMPLATEID
  where 
    IMPORTPROCESS.ID = @ID;