Hi!
I m using sql 2005.I have a table as showing below.
year | Region | loan_amt | pur_id | purpose | |
1981 | Andhra pradesh | $20,000.00 | 1 | Animal Husbandary |
1981 | Arunachal Pradesh | $110,000.00 | 1 | Animal Husbandary |
1981 | Assam | $240,000.00 | 1 | Animal Husbandary |
1981 | Bihar | $75,000.00 | 1 | Animal Husbandary |
1981 | Chhattisgarh | $55,500.00 | 1 | Animal Husbandary |
1981 | Gujarat | $77,500.00 | 1 | Animal Husbandary |
1982 | Goa | $44,888.00 | 1 | Animal Husbandary |
1982 | Himachal pradesh | $4,000.00 | 1 | Animal Husbandary |
1982 | Himachal pradesh | $20,000.00 | 1 | Animal Husbandary |
1982 | Jammu and kashmir | $30,000.00 | 1 | Animal Husbandary |
1882 | Jharkhand | $35,000.00 | 1 | Animal Husbandary |
1982 | Karnataka | $40,000.00 | 1 | Animal Husbandary |
1982 | Kerala | $20,000.00 | 1 | Animal Husbandary |
1982 | Madhya pradesh | $5,000.00 | 1 | Animal Husbandary |
I want to produce report as by using crosstab query as showing bellow
Year Asam Hyadrabad goa arunachal pardesh etc.........
1981 1000.00 2000.00 8000.2 00000 000000 .....
1981
'
'
Is it possible by crosstab query ?or please suggest me another way as early as possible.
Thanx in advance.
Abhishek
http://www.databasejournal.com/features/mssql/article.php/10894_3516331_2
No comments:
Post a Comment