SwePeso (2/17/2011)

---

DECLARE@Sample TABLE

(

hic CHAR(6) NOT NULL,

qry VARCHAR(7) NOT NULL

)

INSERT@Sample

SELECT'00005A', '9130813' UNION ALL

SELECT'00005A', '9130850' UNION ALL

SELECT'00010A', '9130813' UNION ALL

SELECT'00010A', '9130850' UNION ALL

SELECT'00010A', '915216' UNION ALL

SELECT'00010A', '915416' UNION ALL

SELECT'00021A', '9130813' UNION ALL

SELECT'00021A', '9130850'

SELECTs.hic,

s.qry,

f.qry

FROM@Sample AS s

CROSS APPLY(

SELECTx.qry

FROM@Sample AS x

WHEREx.hic = s.hic

AND x.qry > s.qry

) AS f