Código SQL:
Ver originalCREATE TABLE #temp
(
c_codcli VARCHAR(30),
c_cod_pro INT,
n_salcap VARCHAR(30)
)
INSERT INTO #temp VALUES ('16500000036',16015,'1000.00')
INSERT INTO #temp VALUES ('16500000036',16055,'4416.69')
INSERT INTO #temp VALUES ('16500000036',16045,'1279.49')
INSERT INTO #temp VALUES ('16500000063',16045,'2566.66')
INSERT INTO #temp VALUES ('16500000063',16045,'4067.88')
SELECT c_codcli,CASE WHEN c_cod_pro=16015 THEN n_salcap END AS 'Otros',
CASE WHEN c_cod_pro=16055 THEN n_salcap END AS 'apoyo financiero',
CASE WHEN c_cod_pro=16045 THEN n_salcap END AS 'institucional'
FROM #temp
saludos!