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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL selection issue.

Author  Topic 

dexk
Starting Member

1 Post

Posted - 2015-01-16 : 08:50:48
Hi, I was using sql server management studio express and trying to select crosstab data from few table.. I run lot of testing but with no luck.. hope can get someone with experiences can guide me on this. Appreaciate for any help given.

I have 3 table as below imagine.


Do anyone know how to select data to display in crosstab as below imagine??


Thanks

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-16 : 09:06:48
Read this article: http://www.sqlservergeeks.com/sql-server-building-crosstab-queries-part-1/

Then using the ideas, build a query to do what you want. If it still doesn't work, post what you have created and we'll look at it
Go to Top of Page
   

- Advertisement -