I've switched to an AG table that will result in multiple rows being returned. I'm basically getting the same error as you, with everything I try ending in the error 'Result of SELECT more than one row.' I'll keep looking at it and see if I can find a solution.