pivot使用

SELECT  code ,
        [1] ,
        [2] ,
        [3] ,
        [4] ,
        [5]
FROM    ( SELECT    idx = ROW_NUMBER() OVER ( PARTITION BY code ORDER BY webpath ) ,
                    webpath ,
                    code
          FROM      dbo.ProductPictureInfo WITH ( NOLOCK )
          WHERE     PicType = 2
                    AND PicIndex <= 5
        ) AS t PIVOT
        ( MAX(webpath) FOR idx IN ( [1], [2], [3], [4], [5] ) )    AS t
        
ORDER BY t.code