I am getting over 500 single results, heres some sample data to work with

CREATE TABLE #Temp (RepairSheetNr int, unitnr int, groupid char(4), brandId varchar(40), modelId varchar(40), version varchar(40), Type_Fleet char(10), close_date DATETIME, TotalModels INT)

INSERT INTO #Temp

SELECT 5000003, 84, 'EDMN', 'FIAT', 'GRANDE PUNTO 1.2', '8V DYNAMIC 5DR', 'OF','2012-07-31 00:00:00.000', 1

UNION ALL

select 5000016,671,'IDMD','TOYOTA','AVENSIS 2.0D-4D','TERRA DPF 4DR','OF','2012-05-04 00:00:00.000','1'

UNION ALL

select 5000024,472,'CDMD','FORD','FOCUS STYLE 1.6TDCI','STYLE 1.6 TDCI 109PS','OF', '2012-03-01 00:00:00.000','1'

UNION ALL

select 5000058,698,'IDMD','FORD','MONDEO 1.8 TDCI','ECONETIC 09 MY 4DR','OF','2012-05-09 00:00:00.000','1'

UNION ALL

select 5000078,430,'CDMD','OPEL','ASTRA 1.3CDTISC', '95PS 5DR','BB', '2012-03-06 00:00:00.000','1'