Este seria el query....
Código SQL:
Ver originalSELECT DISTINCT(Htxnnum) AS 'transaccion',
Nombre,
Apellido,
TelefonoCasa,
Celular,
CS.HBUSINESSDATE,
cs.codcliente AS 'cedula'
FROM POS_BACKSERVER.SISTEMACLUB.DBO.CLIENTES SC
INNER JOIN HISTORIA.CSM.DBO.CLIENTES CS
ON SC.CEDULA = CS.CODCLIENTE
INNER JOIN HISTORIA.CSM.DBO.CajasSucursal CSU
ON CS.HRegNum = CSU.idCaja
INNER JOIN HISTORIA.CSM.DBO.Sucursales SU
ON CSU.idSucursal = SU.idSucursal
WHERE HTXNMODIFIER IN (0, 1, 2, 3, 4, 5, 6, 9) AND HTXNVOIDMOD IN (0, 1)
AND CS.HBUSINESSDATE BETWEEN '2013/12/01' AND '2013/12/31'
GROUP BY htxnnum,cs.codcliente,Nombre,Apellido,TelefonoCasa,Celular,CS.HBUSINESSDATE
ORDER BY Hbusinessdate DESC