Re: Challenging Query

From: oj (nospam_ojngo_at_home.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 14:26:51 -0800

CTO,

I was looking for a quick output sample of what you want based on your
ddl+sample data. Basically, I wasn't clear of the requirements/intents in
order for me to quickly draft/formulate a solution.

e.g.
col1 col2 col3 col4
---- ----- ----- ----
abc 1 3 2
def 2 2 2

Would you please post the expected output so we can take a closer look.

If you;'re looking for Xtab solutions, you might want to check these out.

If you know in advance the number of columns in the result set, try:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175574.

If you have a variable number of columns, try:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15608

If you want some interesting utilities to do it for you:
http://www.ag-software.com/AGS/xp ags crosstab.asp

RAC at:
www.rac4sql.net

"C TO" <CTO@discussions.microsoft.com> wrote in message
news:106D2F6C-6410-4162-B5D8-6A056E8350C8@microsoft.com...
> The chart with 14 Y-axis values when charting in EXCEL may still be
> generated
> with the following sample data. (Otherwise, I suspect pivot table may
> require). Here is my sample data of the first question, with 29 Y-axis
> values:
>