SHARE
TWEET

Untitled

a guest Apr 21st, 2017 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. )
RAW Paste Data
Top