Advertisement
HC_

Untitled

HC_
Mar 11th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SELECT TOP 10 RUT_CLIENTE, COUNT(DISTINCT IdProducto)
  2. ,CAST(SUBSTRING(RUT_CLIENTE,1,LEN(RUT_CLIENTE) -1) AS INT)
  3. FROM dbo.st_CL_FlujoNeto
  4. WHERE PERIODO > 201701
  5. AND DEFINICION IN('APORTE','RESCATE')
  6. AND LTRIM(RTRIM(MONTO_PESOS_FINAL)) != 'NULL'
  7. --AND CAST(SUBSTRING(RUT_CLIENTE,1,LEN(RUT_CLIENTE) -1) AS INT) <= 20000
  8. AND RUT_CLIENTE != 'NULL'
  9. --AND DEFINICION != 'NEUTRO'
  10. GROUP BY RUT_CLIENTE
  11. HAVING COUNT(DISTINCT IdProducto) > 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement