UFN_BBNC_TRANSACTIONDS_FROMXML

            CREATE function dbo.UFN_BBNC_TRANSACTIONDS_FROMXML(@TRANSACTIONIDS xml) 
            returns table
            as
            return (
                select distinct
                    T.c.value('(@VALUE)[1]','int') AS 'ID'
                FROM   
                    @TRANSACTIONIDS.nodes('/TRANSACTIONIDS/*') T(c)            
                    )