UFN_BATCHTEMPLATE_SPECXML

                create function [dbo].[UFN_BATCHTEMPLATE_SPECXML](@ID uniqueidentifier)
                returns xml
                as
                begin

                    declare @RETURNVALUE xml;

                    select 
                        @RETURNVALUE = BATCHTYPECATALOG.SPECXML 
                    from 
                        dbo.BATCHTEMPLATE
                    left join 
                        dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                    where 
                        BATCHTEMPLATE.ID = @ID;

                    return @RETURNVALUE;

                end;