Código SQL:
Ver originalCREATE TABLE #temp
(
id INT,
producto VARCHAR(20),
debe INT,
haber INT
)
INSERT INTO #temp VALUES (191, 'Listados', NULL ,NULL)
INSERT INTO #temp VALUES (192, 'Productos', 100, NULL)
INSERT INTO #temp VALUES (192, 'Productos', NULL, 100)
INSERT INTO #temp VALUES (192, 'Productos', NULL, 120)
INSERT INTO #temp VALUES (193, 'Servicios', NULL, NULL)
SELECT id, producto,SUM(debe) AS debe,SUM(haber) AS haber FROM #temp GROUP BY id,producto
saludos!