Instead of posting in TSQL forum I posted here. So please forgive me.

I created cross tab in crystal reports, so there was no code for it.

I didn’t understand the second one, but I think we can create string as long there is...

Hi, do you think can we write without the XML?

I figured out why, its because I’m working on SQL server 2005 but my database is in SQL server 2000. So that’s why its giving the error at XML as...

No, the same one which you pasted i'm running.

Hi, when I run the code , its giving me Incorrect syntax near XML.

Jerry can you help me out to arrange them in one column?

Yes Jerry, we can do in that way.

Ok, sorry about it.

First I tried in cross tab itself but I have other fields like sales also. So its not giving the correct records.

Yes, I know. That’s why I’m trying in SQL by writing Stored Procedure.

As the datamart is connected to management Studio, when I’m running it does not allow. So I’m unable to copy to temp table also.

In the Crystal reporting tool also I tried which cannot convert one field into columns, it can convert all the fields which I use in the report or the detail...

I’m not expert at SQL, so that’s why I’m asking for help. If you can atleast give me the code which you used then that will be of great help.

I will use that Stored Procedure for developing a report. In the report user need sales and some other requirements for that state with all the cities one per...