SHARE
TWEET

Untitled

a guest Oct 23rd, 2019 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT  DISTINCT
  2.         TEmp.IdEmpleado,
  3.         FORMATMESSAGE('%s %s', TEmp.Nombres, TEmp.Apellidos) Empleado,
  4.         TEmp.Login Usuario
  5. FROM    Encuesta.MstEncuesta TEnc
  6. INNER JOIN
  7.         Encuesta.MstEncuestaResuelta TEnRes
  8.         ON  TEnRes.IdEncuesta = TEnc.IdEncuesta
  9. INNER JOIN
  10.         MobileSuitCase.MstEmpleados TEmp
  11.         ON TEmp.IdEmpleado = TEnRes.IdEmpleado
  12. WHERE   TEnc.IdEncuesta = 159 AND
  13.         TEnRes.FechaHoraDisp BETWEEN '2019-10-02 00:00:00' AND '2019-10-02 23:59:59'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top