I am gathering data on building permits. I have a business request to reduce each permit's data to one row. Currently, I have an issue where I have multiple lots under each permit, with one row per lot.
What is the best way to change the output to:
The only way I can think to do it is to use a cursor. Does anyone have a better way?