I have thie very simple table:

ID    processtime    cost    category

1        100                50        0 ---    labor
1        200                60        1 ---    sewing
1        300                70        2 ---    boxing

What I want is this:
ID       labortime    laborcost    sewingtime    sewingcost    boxingtime
boxingcost
1            100              50            200                60
300            70

Can someone help, please?

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
create a sp from query output