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:20:24
|
| 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 Mainur rahman shohan |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
|
|
magnetica
Starting Member
36 Posts |
Posted - 2006-09-02 : 06:31:33
|
| Why have you posted loads of the same threads just across different categories of the forum???If you think you know it all?! You know nothing! |
 |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-02 : 06:35:44
|
| I think he was desperate to get an answer ASAP :-)ThanksRishi Maini |
|
|
|
|
|
|
Crosstab query