Eric Barro
ebarro at verizon.net
Mon May 14 11:10:55 CDT 2007
Thanks Arthur...I kinda figured that joining was a pre-requisite to viewing. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Monday, May 14, 2007 9:08 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] [AccessD] Cross Tab Query Help Requested Yes: http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries- and-pivot-tables-in-sql/. However, you may possibly need to join to get to that URL, I'm not sure. Joining the list is free, so no worries. Arthur On 5/14/07, Eric Barro <ebarro at verizon.net> wrote: > > Arthur, > > Do you have the link to the article? > > Eric > > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of > Arthur Fuller > Sent: Monday, May 14, 2007 7:19 AM > To: Access Developers discussion and problem solving > Cc: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] [AccessD] Cross Tab Query Help Requested > > In my experience, the easiest solution was to use static functions in > the first query, and then base the crosstab query on that result set. > > For the SQL Server folks on this list, there is an amazing stored > procedure available at Simple-Talk (www.simple-talk.com) that > dynamically generates cross-tabs as complex as you'd like. One of the > big problems with cross-tabs is that the number of columns might > change from run to run. This stored procedure gets around that. > > In the interests of transparency, let me admit that I write for Simple > Talk, although I did not write this article and wish that I had. The > stored procedure is amazing. > > Arthur > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.0/803 - Release Date: 5/13/2007 12:17 PM