Cross Tab Query

Can anybody help me to write Cross Tab Query in SQL Server 2000.
Thank you,Read up on how to use the "group by" clause of the SQL select statement. If
what you really want is a crosstab, then the best option is to use Excel or
Crystal Reports.
"Ballu" <patel.balwant@.gmail.com> wrote in message
news:1130252772.140880.308340@.f14g2000cwb.googlegroups.com...
> Can anybody help me to write Cross Tab Query in SQL Server 2000.
>
> Thank you,
>|||Ballu,
See:
How do I create a cross-tab or pivot query?
http://www.aspfaq.com/show.asp?id=2462
and
Cross-Tab Reports
http://msdn.microsoft.com/library/d...r />
_04j7.asp
HTH
Jerry
"Ballu" <patel.balwant@.gmail.com> wrote in message
news:1130252772.140880.308340@.f14g2000cwb.googlegroups.com...
> Can anybody help me to write Cross Tab Query in SQL Server 2000.
>
> Thank you,
>|||
I tried that with Excel...My problem is that
My table is as follows.
product stock orderno orderqty
1 10 10 10
1 10 12 5
2 3 14 6
2 3 12 3
Now I have to show data in following way...
order no
product stock 10 12 14 totalorderqty
1 10 10 5 15
2 3 0 3 6 9
When I tried with excel and puts columns product and stock in row area
its formats data on products and stocks while here stock column remains
the constant
*** Sent via Developersdex http://www.examnotes.net ***|||"Ballu" <patel.balwant@.gmail.com> wrote in message
news:1130252772.140880.308340@.f14g2000cwb.googlegroups.com...
> Can anybody help me to write Cross Tab Query in SQL Server 2000.
Yes...RAC can:)
www.rac4sql.net