hiyusuf (9/19/2011)
Dear All,I am creating a report of State wise Article Price for all states of India.
You should be doing this in SSRS (or whatever reporting software you are using) instead of T-SQL. SSRS is much better equipped to create crosstabs.
If you insist on using T-SQL, then search this site for articles on "crosstabs" or "dynamic crosstabs".
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA