I will be sent an array of postcodes from the API. I need to iterate through each row and bring back the latitude and longitude from the table and then create a string from the latitude and longitude to create a polygon.
I will be capturing the array in my table type.
Is it possible to iterate through each record without using cursors?
Or is there a way of doing this by set based operation.