Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions
. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum
. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
SQL help transposing data
I'm trying to figure out a method for updating a column with data which would typically generate multiple rows onto a single row seperateed by a comma.
I have a table that shows the states a restuarant operates in. The data is stored thusly
I want to pull it in as "McDonalds" "NY, TX, AK"
Any thoughts? I'm stumped