Another way to do this is by using a cross tab. I used Erikur's data as a starting point. This will be better performance wise because it doesn't have to hit the table more than once.

;WITH CODE_COLS AS

(

SELECT

ROW_NUMBER() OVER (PARTITION BY PH.HISTORY_ID ORDER BY (SELECT NULL)) AS PH_RID

,PH.HISTORY_ID

,PH.CODE_ID

, POLICY_DETAILS_ID

FROM @POLHIST PH

)

select ph.POLICY_DETAILS_ID,

ph.HISTORY_ID,

MAX(case when ph.PH_RID = 1 then CODE_ID end) as CODE1,

MAX(case when ph.PH_RID = 2 then CODE_ID end) as CODE2,

MAX(case when ph.PH_RID = 3 then CODE_ID end) as CODE3,

MAX(case when ph.PH_RID = 4 then CODE_ID end) as CODE4,

MAX(case when ph.PH_RID = 5 then CODE_ID end) as CODE5

from CODE_COLS ph

group by ph.POLICY_DETAILS_ID, ph.HISTORY_ID

You can read more about the concept by reading the articles in my signature about cross tabs.