Advertisement
Guest User

Untitled

a guest
Apr 21st, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. ;WITH CTE2 AS
  2. (
  3. SELECT
  4. [AQU_IDBPCodigoIC]
  5. ,[AQU_IdContrato]
  6. ,[AQU_IDBPCategoriaCredito]
  7. FROM zaux.TmpUniversoBaseReportes REP
  8. INNER JOIN @UniversoReportes Univ
  9. ON REP.AQU_OidReporte = Univ.OidReporte
  10. GROUP BY
  11. [AQU_IDBPCodigoIC]
  12. , [AQU_IdContrato]
  13. , [AQU_IDBPCategoriaCredito]
  14. HAVING Count(*) > 1
  15. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement