Thanks for your support so far.

I just ran DBCC CHCKDB before repair_allow_data_loss and it ran without any errors.

So here is what I am planning to do:

* Restore the backup of...

Hi Gail thank you for your prompt response.

I ran repair_allow_data_loss because of panic and also it was suggested at after running DBCC CHECHDB. I ran this on a different...

Here is how I managed to get it working. If it helps anyone, it would be great.

My problem was I needed the values of Field1 to become the Column Headings...

Well thanks everyone.

I have managed to solve it mysef.

I have read the original article about Cross Tabs on BOL.

My requirement is different. In the article it uses static statments to insert records. In my case no. of rows...

I need to display country and its currency. Instead of display the 3 character country code, i would like to display Currency Symbol. Front end is Vb.Net and will save...

Could you please tell me how did you manage to insert currency name and symbol in the table.

Is it possible for you to give me an insert statement on how...