Please start any new threads on our new site at 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 

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??


Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-16 : 09:06:48
Read this article:

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 -