USP_BATCH_GETLISTBYDUPLICATERECORDCHECKSEARCHLIST

            create procedure dbo.USP_BATCH_GETLISTBYDUPLICATERECORDCHECKSEARCHLIST
            (
                @SEARCHLISTID uniqueidentifier
            )
            as
            begin
                set nocount on;

                select
                    SPECXML
                from dbo.BATCHTYPECATALOG
                where
                    SPECXML.value('declare namespace bbspec="bb_appfx_batchtype";
                        data(/bbspec:BatchTypeSpec/bbspec:DuplicateRecordCheck/@SearchListID)[1]', 'uniqueidentifier') = @SEARCHLISTID
            end