The question itself is obscure, so why not?

"Not able to create" is a little vague. Specifics please... 🙂

Does the "New Table" option appear when you right click? If not,...

That one is a winner alright.

Maybe. It all depends.

All xp_cmdshell does is launch code outside of SQL.

From Books Online:

xp_cmdshell (Transact-SQL)

Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows...

But I thought the frozen ones hurt more, Jeff. 😛

I guess my question is: If you see an answer that you think misses the mark, why you don't just go ahead and answer it as you see fit?...

Please don't post multiple times. Also, adding URGENT doesn't accomplish anything. This is a free forum whose participants volunteer to help each other out. It...

Yes, and it gets the job done with only one pass through the source table.

-- unpivot only

SELECT Customer,Shop

,max(case when [AM/PM] = 'AM' then PCT else null end) as AM

,max(case...

Really good point. Thanks for the heads up, BB.

No promises about performance with this solution.

declare @sample table (Customer char(5), [AM/PM] char(2), ShopA int, ShopB int, ShopC int)

insert into @sample

select 'Cust1','AM',10, 15, 25 union all

select 'Cust1','PM',30, 10, 20 union...

You can also find it online through a web browser at:

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Trudye, just to be clear. If you switch to using OUTPUT, I wouldn't bother with IF EXISTS at...

I know what you mean, Jeff. Fortunately in this , the OP came back with their own solution which they were working on while I was answering.

Good for you, Trudye. 🙂

Two hints for the future:

I notice you are saving "before" images of the rows which will be updated. You might want...

Makes sense.

Hope you didn't mind my taking pity on the OP who didn't have a clue about how to do a set-based UPDATE. ...