Uses of the SPUPad

The SPUPad can be a helpful option if you are designing UDFs or UDAs that do the following types of actions:

• Return multiple result columns; currently, UDFs and UDAs cannot return multiple results unless they are encoded in a string and you have UDXs that return the string and extract values from that string.
• Process by using a lookup table of values that can speed processing for the UDX. For example, you might want to create a temporary table of facts or values that might help the UDFs or UDAs to run more quickly.
• Serve as or use a common engine-style UDF to initialize a program or routine that is passed as an argument of a UDF or UDA.