Eliminar valores duplicados
Publicado por Guillermo (1 intervención) el 20/10/2017 16:58:45
BUenos dias tengo la siguiente QUERY
El tema que no quiero que me cuente los valores duplicados de resourceid ya probe con el DISTINCT pero no logro hacerlo, desde ya muchas gracias.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
SELECT
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/HOSPITAL%' THEN 1 ELSE NULL END) as 'Hospital',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/PARQUE%' THEN 1 ELSE NULL END) as 'Parque Austral',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/QUANTUM%' THEN 1 ELSE NULL END) as 'Quantum',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/CHAMPAGNAT%' THEN 1 ELSE NULL END) as 'Champagnat',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/ESCOBAR%' THEN 1 ELSE NULL END) as 'Escobar',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/LUJAN%' THEN 1 ELSE NULL END) as 'Lujan',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/OFFICIA%' THEN 1 ELSE NULL END) as 'OFFICIA',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/SAN MIGUEL%' THEN 1 ELSE NULL END) as 'San Miguel',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/AS%' THEN 1 ELSE NULL END) as 'AS - Tucuman',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 like 'HOSPITAL.AUSTRAL/EQUIPOS (NUEVO)/SEDES/SKYTEL%' THEN 1 ELSE NULL END) as 'SKYTEL',
COUNT (CASE WHEN v_RA_System_SystemOUName.System_OU_Name0 <> '' THEN 1 ELSE NULL END) as 'Total'
FROM
System_DISC
LEFT OUTER JOIN Add_Remove_Programs_DATA
ON System_DISC.ItemKey = Add_Remove_Programs_DATA.MachineID
LEFT OUTER JOIN v_RA_System_SystemOUName
ON Add_Remove_Programs_DATA.MachineID = v_RA_System_SystemOUName.ResourceID
WHERE
((Add_Remove_Programs_DATA.DisplayName00 LIKE 'Microsoft office%' AND Add_Remove_Programs_DATA.DisplayName00 LIKE '%'+@Version)
AND Add_Remove_Programs_DATA.DisplayName00 not LIKE '%MUI%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%Live%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%Excel%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%powerpoint%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%proof%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%communicator%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%sharepoint%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%word%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%visual%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%visio%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%project%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%access%'
AND Add_Remove_Programs_DATA.DisplayName00 NOT LIKE '%click%'
)AND System_DISC.Client0=1
El tema que no quiero que me cuente los valores duplicados de resourceid ya probe con el DISTINCT pero no logro hacerlo, desde ya muchas gracias.
Valora esta pregunta
0
