Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 483 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

Creating Cross Tab Queries in SQL Server

Available for Members. This is an off-site link. Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(Michael Schmalz) Before I started using Microsoft Access heavily, I did analysis work with PivotTables in Excel. Moving over to Microsoft Access, I found that using cross tab queries allowed me to do similar work but not to the same degree of detail.

When I made the next leap to SQL Server, I was surprised to find that there was not an easy solution inside SQL Server to perform a cross tab query. When you are working with a linked SQL Server table in Access, you can simply perform the cross tab from Access. But there are times when you may want to perform the cross tab query on the server, or you need to perform it and you are not using Access.

I could not find any adequate solutions to automatically produce a cross tab, so I decided to see if I could create it myself.

 Read this article...
 Related Articles - For Members.
Nulls, Plain and Simple
Migrating from Oracle to SQL Server 2000 Part –I
From xp_sendmail to safe_sendmail
Debugging/Tuning Your PL/SQL With Dbms_trace
Modeling Hierarchical Relationships: Schema Management Tools
The True Test of a Good DBA
Tips & Tricks to Minimize Profiler Load
Use SQL 2K Functions To Optimize Your Queries - Part 1



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004