select
		VRS.NAME0 [Имя_PC] ,
		VRS.DESCRIPTION0 [Пользователь],
		COMP.model0 [Модель_PC], 
		CPU.SLOTID0  [Слот_Памяти],
		CPU.MAXBANDWIDTH0 [Частота], 
		CPU.SIZE0 [Оперативная Память], 
		CPU_MP.MEMORYTYPE0 [Вид Памяти], 
		CPU_MP.Channels0 [Режим Работы],
		(case when CPU.manufacturer0 <> '' then CPU.manufacturer0 else 'Unknown' end)  [Производитель]
		from V_R_SYSTEM as VRS
		Left join  [dbo].[v_GS_CPUZ_RAM] as CPU
on CPU.RESOURCEID=VRS.RESOURCEID
		left join  [dbo].[v_GS_COMPUTER_SYSTEM] as COMP
on COMP.RESOURCEID=VRS.RESOURCEID
		left join [dbo].[v_GS_CPUZ_MB] as CPU_MP
on CPU_MP.resourceID = VRS.resourceID
		where VRS.AD_Site_Name0 like '%ростов%'
group by VRS.name0,COMP.model0,CPU.SLOTID0,CPU.MAXBANDWIDTH0,CPU.SIZE0,CPU_MP.MEMORYTYPE0,CPU_MP.Channels0,CPU.manufacturer0,VRS.RESOURCEID,VRS.DESCRIPTION0
order by VRS.RESOURCEID, CPU.SLOTID0

сравнивал бы каждую строку с последующей.