asked on

SQl Server 2008 table

Hi,
I have a table:

Open in new window

I need a view in the format:

10        1  2  3
110	      1  2  3
.
.
.

24010   4  5

Open in new window

Phillip Burton

with mynewtable as
(select field1, field2
from mytable)
select field1, isnull([1],0) as [1], isnull([2],0) as [2], isnull([3],0) as [3], isnull([4],0) as [4], isnull([5],0) as [5], isnull([6],0) as [6]
from mynewtable
pivot (sum([field2]) for field2 in ([1],[2],[3],[4],[5],[6])) as pvt

Open in new window

ASKER CERTIFIED SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial