?
Solved

Cross tab query in SSMS 2005

Posted on 2009-04-28
3
Medium Priority
?
375 Views
Last Modified: 2012-05-06
Can someone explain to me the easiest way to create a Cross Tab query in SSMS 2005.  I am very familiar with how to do it in MS Access, but i cannot find a wizard/easy way to do it in SSMS 2005
0
Comment
Question by:szadroga
  • 3
3 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24252721
have a look at screen shot
image.jpg
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24252731
you can add more table by right clicking in top right panel.
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 2000 total points
ID: 24252741
BTW. don't forget to use icons at left top corner, I marked it with red circle.

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question