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',...

Craig Farrell (2/17/2011)

---

Can you post the ddl and some sample data that would provide us the background for what you're looking to generate:

qry_id_2combo hic_number

qry_1&2 123456789A

qry_1&2 987654321A

qry_1&3 456789123B

We're guessing as to...

mister.magoo (2/16/2011)

---

Do you mean that out of the 16 qry_id values in the table, you just want rows that match two of those qry_id values.

e.g. For table DEV_QRY_QC_HCC_131 containing these...

Thanks, I'll try this...