Solving problems like this is very easy with the RAC utility for S2k.You concentrate on the problem and not the messy convoluted sql code to solve it.With RAC you could...

Check out the RAC utility for S2k.RAC is similar to Access crosstab but much more powerful with many features/options.And like Access it is easy to use.

http://www.rac4sql.net

Check out the RAC faq for an example of using the result of a dynamic crosstab in ASP.

http://www.rac4sql.net

P.S. you'll get all the horsepower you need with RAC

Antares686 writes:

>Which specific functionality are you referring to?

In sql99 its referred to as analytic/windowing functions.It's what MS is trying to implement in Sql 2005 with constructs like row_number(),rank,dense_rank(),partition and order...

And just how do you know anything about the code in RAC?

You can't do things like this easily and efficiently in S2k because it lacks the sql99 functionality found in its competition (ie.Oracle/Db2).You can make up for this by using the...

You don't need to think of a way to this with the RAC utility for S2k.Check out the @concatenate parameter and RAC will create a table just as you want.Simple...

To easily solve all types of pivoting problems with minimal coding check out the RAC utility for S2k.As easy as Access crosstab query but much more powerful with many features/options.

http://www.rac4sql.net