Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ;WITH CTE2 AS
- (
- SELECT
- [AQU_IDBPCodigoIC]
- ,[AQU_IdContrato]
- ,[AQU_IDBPCategoriaCredito]
- FROM zaux.TmpUniversoBaseReportes REP
- INNER JOIN @UniversoReportes Univ
- ON REP.AQU_OidReporte = Univ.OidReporte
- GROUP BY
- [AQU_IDBPCodigoIC]
- , [AQU_IdContrato]
- , [AQU_IDBPCategoriaCredito]
- HAVING Count(*) > 1
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement