Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shohan_db
Starting Member
36 Posts |
 Posted - 2006-09-02 : 04:35:30
|
| Crosstab conceptsI m using Sql server 2000 version I want to create a simple crosstab… as like the followsMy table is as like Date warehouse (WH) Delivery No7/7/2006 10 10-1 7/7/2006 20 20-17/7/2006 20 20-27/7/2006 30 30-18/7/2006 10 10-28/7/2006 10 10-311/7/2006 30 30-211/7/2006 20 20-3 I want to make a report using crosstab in iReport….. I want report will be as like Date WH10 WH20 WH30 total delivery7/7/2006 1 2 1 48/7/2006 2 0 0 211/7/2006 0 1 1 2 my questions are: i create a crosstab procedure and it is running but01. I want to know the query.02. How I count/sum the wh in the crosstab? (cause the WH is arrange as row in my database table )I want step by step instructions I have not clear concepts about crosstab, but I know crosstab will give the solution of this problem Please help…… Thanks shohan |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
crosstab query