Topic: Aggregating statuses from subsites
We have a user function which produces a text string listing all the statuses of a particular location. I modified this from ufn_GetDesignations in order to get the desired result. It works fine.
Trouble is, I now want to modify it to return all statuses applied to the location and all of its subsites. Early attempts began with some code modified from the JNCC_L6 xml report, which creates a temporary table & loops through all the subsites of a location populating the table with location keys, then joins the table to others to extract the data needed.
My new code looks great, but I can't use it because I am informed that it is not possible to create temporary tables etc. within a user function.
Any suggestions of how to get around this would be gratefully received.
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre