I would point out that 'generic' is implied by the concept of a 'utility'.

As for your repeating yourself, perhaps you feel that something like RAC robs you of coding. In...

Hello Rowan,

What a pleasure to meet a kindred spirit! That you have not lost your intellectual  curiosity speaks volumns. It is an industry that all to often rewards complacency and...

I present the easiest and most profound solution:

http://www.rac4sql.net/onlinehelp.asp?topic=236

enjoy

With all due respect to the efforts of Mr. Peter Larrson the be all and end all for dynamic crosstabs in ms sql server is the RAC utility @:

If anyone would like to take a crack at reproducing the functionality of RAC bring it on

For professional crosstab development check out RAC...

Check out the RAC utility for S2k.It makes both static and dynamic crosstabs with multiple aggregates very simple.Why bother with code?

http://www.rac4sql.net

The RAC utility will easily generate all kinds of static and dynamic crosstabs.Unless of course you want to try to reinvent the wheel or fumble thru a lot of tortuned...

For solution to pivoting/xtabs and much more check out RAC.Similar to Access crosstab but much more powerful with many features/options.And just as easy.

http://www.rac4sql.net

Check out the Rac utility.Similar to Access Crosstab but much more powerful with many features/options.And just as easy to use.

http://www.rac4sql.net

Check out the @split parameter in the RAC utility @

http://www.rac4sql.net

An easy and comprehensive solution to pivoting/xtabs has been around for a while.

Check out RAC @

http://www.rac4sql.net

We will be optimizing a solution for 2005.

The be-all and end-all of pivoting/xtabs on sql server = RAC @

http://www.rac4sql.net

And it's really as easy as its name

For all types of pivoting/xtabs check out the RAC utility @

http://www.rac4sql.net

Similar to Access (ie. dynamic pivoting) but much more powerful as well as easy to use.

As for the 2005 PIVOT...

Check out the RAC utility.It's similiar to Access crosstab but much more powerful.No messy sql coding required

http://www.rac4sql.net

You can check out the RAC utility for S2k.Similiar in concept to the Access crosstab query but much more powerful and just as easy.

http://www.rac4sql.net