I'd like Stored Procedures and Functions to be able to have array parameters, and Functions should be able to return an array.
I've started doing a lot of work with arrays, but unfortunately they are only local to the stored procedure they were created in. This dramatically limits the usefulness of arrays.
For example. I can't transfer the array I've built in Procedure_A to another procedure like Procedure_B. So all of the array processing has to be done in one stored procedure.