UFN_USERSETTINGS_GETBATCHSETTINGS

            Create function UFN_USERSETTINGS_GETBATCHSETTINGS(@BATCHID uniqueidentifier, @APPUSERID uniqueidentifier) returns xml
            as
            begin
                declare @xml xml
                set @xml=N''
                select @xml = BATCHUSERSETTINGS.SETTINGS from dbo.BATCHUSERSETTINGS 
                    inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHUSERSETTINGS.BATCHTYPECATALOGID
                    inner join dbo.BATCH on BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID            
                    where BATCH.ID = @BATCHID and BATCHUSERSETTINGS.APPUSERID = @APPUSERID;

                return @xml
            end