I'm not sure if this can be done in one stored procedure. I got it working using nested views but