The ladder I want to combine the rows into one record.

the code

SELECT

p.HPROP,

p.STYPE,

p.SVALUE,

NSFFee = CASE WHEN p.STYPE = 'nsffee' THEN p.hvalue END,

SecDepIntRate = CASE WHEN p.STYPE = 'DDEPOSITINTEREST' THEN p.hvalue END

FROM PROPOPTIONS P

WHERE p.hprop = '240' and p.STYPE IN ('nsffee','DDEPOSITINTEREST')

the result

HPROPSTYPE SVALUENSFFeeSecDepIntRate

240DDEPOSITINTEREST0NULL3000.0000

240NSFFee 50.0000NULL

what I'm looking for is

hprop nsffee SecDepIntRate

240 50.0000 3000.0000