USP_IMPORTFIXEDWIDTHFILETEMPLATE_GETBYID

CREATE procedure dbo.USP_IMPORTFIXEDWIDTHFILETEMPLATE_GETBYID
(
    @ID uniqueidentifier  
)
with execute as caller
as

    set nocount on;

    select 
        ID,
        NAME,
        BATCHTEMPLATEID,        
        FILENAME,
        SITEID,    
        DETAILCOLUMNMAP,            
        DETAILROWPREFIX,
        BATCHSUMMARYPREFIX,
        FILESUMMARYPREFIX,      
        FIXEDWIDTHDEFINITION, 
        BATCHRECORDCOUNTSTARTPOSITION,
        BATCHRECORDCOUNTENDPOSITION,
        BATCHREVENUECOUNTSTARTPOSITION,
        BATCHREVENUECOUNTENDPOSITION,
        FILERECORDCOUNTSTARTPOSITION,
        FILERECORDCOUNTENDPOSITION,
        FILEREVENUECOUNTSTARTPOSITION,
        FILEREVENUECOUNTENDPOSITION,
        FIELDIDCOLUMN,
        STARTPOSITIONCOLUMN,
        ENDPOSITIONCOLUMN,
        LAYOUTFILEHASHEADERROW,
        TSLONG,
        (select dbo.UDA_BUILDLIST(IMPORTPROCESS.NAME) from dbo.IMPORTPROCESS where FIXEDWIDTHFILETEMPLATEID = IMPORTFIXEDWIDTHFILETEMPLATE.ID) as IMPORTUSAGE
    from
        dbo.IMPORTFIXEDWIDTHFILETEMPLATE 
  where
        IMPORTFIXEDWIDTHFILETEMPLATE.ID = @ID;