O posibila solutie:
CREATE TABLE T
(
nr VARCHAR(25) NOT NULL,
doc VARCHAR(25) NOT NULL,
chit VARCHAR(25) NOT NULL,
suma MONEY NOT NULL
)
GO
INSERT INTO T VALUES ('0370','hnv3','curent',10)
INSERT INTO T VALUES ('0370','hnv3','rest',15)
INSERT INTO T VALUES ('0370','hnv3','access',20)
INSERT INTO T VALUES ('0470','hnv4','curent',100)
INSERT INTO T VALUES ('0470','hnv4','rest',150)
INSERT INTO T VALUES ('0470','hnv4','access',200)
GO
SELECT nr,
doc,
SUM(CASE WHEN chit='curent' THEN suma ELSE 0 END) AS curent,
SUM(CASE WHEN chit='rest' THEN suma ELSE 0 END) AS rest,
SUM(CASE WHEN chit='access' THEN suma ELSE 0 END) AS access
FROM T
GROUP BY nr, doc