SQL help

JayJ24 · 10-02-2009, 08:30 AM

Not sure if this is the forum topic i should be under but I will see if maybe i can get some help.

Im fairly new to SQL and well practicing different things. One of the things that I am stuck on and have no idea how to do it but want to learn is this.

I have a table with 2 columns

AccountID Events

111111 Movies
111111 Concert
111111 Basketball
222222 movies
333333 basketball
222222 football
111111 concert
222222 movies
333333 sports

Basically something of that sort is what i have my practice table setup as. And well what i would like to do is figure out how to write a query that grabs one account id and list all its events in one row such as this

AccountID Event1 Event2 Event3 Event4
111111 movies basketball concert concert
222222 movies football movies
333333 sports basketball

Sort of like that above is that possible and where would i start to learn how to write such a query thanks for all the help

JayJ24 · 10-02-2009, 08:45 PM

If anyone can please at least point me in the right direction of what i should be reading. Like what type of query would i need to learn in order to be able to accomplish this.

Thanks

katby1234 · 10-05-2009, 10:36 AM

I found this article and maybe it can help:
http://granitepillar.com/en/Blogs/Se...res092909.aspx
http://granitepillar.com/en/Blogs/Servers/Servers_SQLFeatures092909.aspx

10-02-2009, 08:30 AM	#1 (permalink)
JayJ24 Registered User Join Date: Jan 2008 Posts: 49 OS: Windows 7	SQL help Not sure if this is the forum topic i should be under but I will see if maybe i can get some help. Im fairly new to SQL and well practicing different things. One of the things that I am stuck on and have no idea how to do it but want to learn is this. I have a table with 2 columns AccountID Events 111111 Movies 111111 Concert 111111 Basketball 222222 movies 333333 basketball 222222 football 111111 concert 222222 movies 333333 sports Basically something of that sort is what i have my practice table setup as. And well what i would like to do is figure out how to write a query that grabs one account id and list all its events in one row such as this AccountID Event1 Event2 Event3 Event4 111111 movies basketball concert concert 222222 movies football movies 333333 sports basketball Sort of like that above is that possible and where would i start to learn how to write such a query thanks for all the help

10-02-2009, 08:45 PM	#2 (permalink)
JayJ24 Registered User Join Date: Jan 2008 Posts: 49 OS: Windows 7	Re: SQL help If anyone can please at least point me in the right direction of what i should be reading. Like what type of query would i need to learn in order to be able to accomplish this. Thanks

10-05-2009, 10:36 AM	#3 (permalink)
katby1234 Registered User Join Date: Sep 2009 Posts: 1 OS: XP	Re: SQL help I found this article and maybe it can help: http://granitepillar.com/en/Blogs/Se...res092909.aspx http://granitepillar.com/en/Blogs/Servers/Servers_SQLFeatures092909.aspx