USP_GETBATCHDATA

            CREATE procedure dbo.USP_GETBATCHDATA
            (
                @BATCHID uniqueidentifier
            )
            as 

            set nocount on;

            select 
                BATCHTYPECATALOG.EDITROWDATAFORMTEMPLATEID, 
                BATCHTEMPLATE.FORMDEFINITIONXML,
        BATCHTEMPLATE.BATCHTYPECATALOGID
            from dbo.BATCH 
            inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = BATCH.BATCHTEMPLATEID 
            inner join dbo.BATCHTYPECATALOG on BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID 
            where BATCH.ID = @BATCHID;