세로로 출력되어있는 데이타를 품목별 프로젝트별 가로로 표현하는 쿼리좀 부탁드립니다.

아래와 같고요. 문제는 프로젝트 코드가 가변적이라는것입니다.

즉 가변적인 프로젝트코드가 화면상에서는 타이틀(low명이 되는것이지요)

너무 어렵네요.

ps - 저의 ms-sql버전장 pivot은 지원이 되지않습니다.

Item_code(품목코드)        project_code(프로젝트코드)           Qty(소요량)

A11                                    10-001                              50
A11                                            10-002                                       30
A12                                            10-001                                       60
A13                                            10-009                                       70
A13                                            10-004                                        30
 ;                                                   ;
;                                                    ;
;                                                   ;
;                                                    ;
;                                                    ;                                 
;

------------------------------------------------>
                       
Item_code   10-001(프로젝트1)    10-002(프로젝트2)      10-004(프로젝트3)       10-009(프로젝트4)       ''       ''           ''
A11                                  50                                 30                                   
A12                                  60
A13                                                                                                                                                   30                                           70  
;
;