That didn't exactly work out like I needed it to. But you gave me an idea. I really appreciate the help. Thank you.

Here's what I ended up using

SELECT

locationId, locationId AS...

Ahh crap. I see now. Not enough sleep last night.

Sample data:

Not sure why it...