USP_IMPORTDELIMITEDFILETEMPLATE_GETBYID

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

    select 
        IMPORTFILETEMPLATE.ID,
        IMPORTFILETEMPLATE.NAME,
        IMPORTFILETEMPLATE.BATCHTEMPLATEID,        
        IMPORTFILETEMPLATE.FILENAME,
        IMPORTFILETEMPLATE.SITEID,    
        IMPORTFILETEMPLATE.DETAILCOLUMNMAP,            
        IMPORTFILETEMPLATE.HASHEADERROW,
        IMPORTFILETEMPLATE.DETAILROWPREFIX,
        IMPORTFILETEMPLATE.BATCHSUMMARYPREFIX,
        IMPORTFILETEMPLATE.FILESUMMARYPREFIX,
        IMPORTFILETEMPLATE.FILEDELIMITER,
        IMPORTFILETEMPLATE.BATCHRECORDCOUNTCOLUMNNAME,
        IMPORTFILETEMPLATE.BATCHREVENUETOTALCOLUMNNAME,
        IMPORTFILETEMPLATE.FILERECORDCOUNTCOLUMNNAME,
        IMPORTFILETEMPLATE.FILEREVENUETOTALCOLUMNNAME,
        IMPORTFILETEMPLATE.DELIMITEDHEADERROW,
        IMPORTFILETEMPLATE.TSLONG,
        (select dbo.UDA_BUILDLIST(IMPORTPROCESS.NAME) from dbo.IMPORTPROCESS where DELIMITEDFILETEMPLATEID = IMPORTFILETEMPLATE.ID) as IMPORTUSAGE
    from 
        dbo.IMPORTFILETEMPLATE
    where 
        IMPORTFILETEMPLATE.ID = @ID;