Ver Mensaje Individual
  #9 (permalink)  
Antiguo 15/07/2015, 07:28
Avatar de Libras
Libras
Colaborador
 
Fecha de Ingreso: agosto-2006
Ubicación: En la hermosa perla de occidente
Mensajes: 7.412
Antigüedad: 17 años, 9 meses
Puntos: 774
Respuesta: Problema con Consulta en SQL

Código SQL:
Ver original
  1. SELECT alias.SKILL,
  2. SUM(alias.t_hold+alias.t_talk)/ SUM(alias.n_inb) AS TMO
  3. FROM
  4. (
  5. SELECT 'UNIMARC' AS SKILL,
  6. t_hold,
  7. t_talk,
  8. n_inb,
  9. time_key
  10. FROM R_GA_UNIM_DAY
  11. UNION
  12. SELECT 'MASISA' AS SKILL,
  13. t_hold,
  14. t_talk,
  15. n_inb,
  16. time_key
  17. FROM R_MASISA_DAY
  18. UNION
  19. SELECT 'BANCO' AS SKILL,
  20. t_hold,
  21. t_talk,
  22. n_inb,
  23. time_key
  24. FROM R_GA_BFA_DAY BF
  25. UNION
  26. SELECT 'SECURITY' AS SKILL,
  27. t_hold,
  28. t_talk,
  29. n_inb,
  30. time_key
  31. FROM R_SECUCO_DAY
  32. UNION
  33. SELECT 'SECURITY' AS SKILL,
  34. t_hold,
  35. t_talk,
  36. n_inb,
  37. time_key
  38. FROM R_SECUPC_DAY
  39. ) AS alias
  40. WHERE alias.time_key BETWEEN ('20150629') AND ('20150705')
  41. GROUP BY alias.SKILL
__________________
What does an execution plan say to t-sql query? Go f**k yourself, if you are not happy with me