the query would be output like so (just like an access crosstab query):
blue green red
shirt 1 6 2 1
shirt 2 1 0 0
Unfortunately there is no crosstab query in SQL Server, so what I've
been doing
is taking the query and doing a fair bit of code to get the query into
the format
shown above. I'm wondering if there is an easier way to do it.
Thanks,
Pete
>>> [EMAIL PROTECTED] 1/14/2005 6:08:40 AM >>>
Peter,
Maybe it's early morning for me, but I'm not sure what you mean by
'crosstab' from the information you have given...?
Some more clarification please?
Mark
On Thu, 13 Jan 2005 11:33:16 +0800, Peter Galipo
<[EMAIL PROTECTED]> wrote:
> Morning All,
>
> I've run a query that I want to output in crosstab format.
>
> The data in the query might look something like this:
>
> shrit 1 - blue - 6
> shirt 1 - green - 2
> shirt 1 - red - 1
> shirt 2 - blue 1
>
> and so on.....
>
> Usually what I do is loop over the query and put it into a struct so
> that I can output the data as a crosstab.
>
> Is there an easier way to do this?
>
> Cheers,
>
> Pete
>
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
ICQ: 3094740
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
