Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karandhanu
Starting Member
2 Posts |
 Posted - 2010-03-11 : 14:26:51
|
| Hi there i have two tables one is members table which give me Firstname, last name in rows and then i have event table which gives me dateStart(this is a column name) as datetime. and both of these tables are joined thru two other tables memberStatus and SeasonHere is the details for each tabletable member has memberID(PK),firstname,lastnametable memberStatus has memberStatusID(PK),memberID(FK),seasonID(FK)table Seasonhas seasonID(PK)table eventhas eventID(PK), seasonID(PK),datestart(this is datetime format)now what i am try to this write a query which can work in visual studio for ASP.NET which give me firstname , last name as row and datestart as columnfor exampleright now this is what i getfistname lastname datetimejohn D march 1John D march 2john D march 3mike s march 1mike s march 2mike s march 3what i want is fistname lastname datetimejohn D march 1 march 2 march 3mike s march 1 march 2 march 3 remember fistname and last name are coming out from one table (member)and datetime from an another table(event) |
|
|
cda2007
Starting Member
17 Posts |
Posted - 2010-03-11 : 18:41:29
|
| This might help:[url]http://it.toolbox.com/blogs/db2luw/pivot-query-12757[/url] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SQL pivot or CASE dont know