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