UFN_MATCHINGGIFT_PUTSINGLEDESIGNATIONINSPLITSXML

            CREATE FUNCTION dbo.UFN_MATCHINGGIFT_PUTSINGLEDESIGNATIONINSPLITSXML
            (
                @SINGLEDESIGNATIONID uniqueidentifier,
                @AMOUNT money
            )
            returns xml
            as
            BEGIN

                -- create temp table to hold splits

                declare @SPLITSLIST table
                (
                    AMOUNT money,
                    DESIGNATIONID uniqueidentifier
                )

                -- Load temp table with current splits

                insert into @SPLITSLIST(AMOUNT, DESIGNATIONID) 
                    values(@AMOUNT,@SINGLEDESIGNATIONID);

                RETURN
                (
                    select AMOUNT, DESIGNATIONID 
                        from @SPLITSLIST 
                        for xml raw('ITEM'),type,elements,root('SPLITS'),binary base64
                )
            END