It works for me. Thanks.

Good idea to order by original column.

Thank you very much. Now all is working.

The key is "You need to give you table an alias"

It is working great.

One more question, I want to insert the result into a temp table but code below did not work.

Something wrong with my code?

select * into #myinvoice from...

I found the code here but no test data only screen shot.

http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

Both of them are working. Thanks

It works great.

Thank you.

Hi, Sean Lange,

I searched your posts but did not find out.

Can you give me a link? I want to learn CrossTab query.

Never mind.

I fixed it by search in

http://www.activemodules.com/activeforums/kb/incorrect-syntax-near-pivot-sql-compatibility-level/

I do not know how to post real table but I did the same case using .net in application (create a dataset and then looping in dataset).

Now, I want...

In fact, in real table there are about 20 colums and 200 ID need to check cell by cell.

I do not think that without loop can do it.

Can someone help...

This is the original table named as COLOR

COLOR

ID----BLUE---RED---YELLOW

111---X--------------------

222-------------X--------X

333---X--------------------

444-------------------------

I need a loop to check above table cell by cell and then update another table.

The final result is table named...

Yes, I am working as programmer in Access, VB, VB.NET and SQL server for a few years. Now, need to learn DW.

It means that just keep "BEGIN TRAN" without "SET XACT_ABORT ON" if I want to roll back if any error occurs?

I call this stored procedure from one asp.net app.

If transaction roll back, does app catch an error message?