SELECT		q1.qry_id,
		q2.qry_id,
		h.hic_number
FROM		(
			SELECT	DISTINCT
				qry_id
			FROM	dbo.DEV_QRY_QC_HCC_131
		) AS q1
INNER JOIN	(
			SELECT	DISTINCT
				qry_id
			FROM	dbo.DEV_QRY_QC_HCC_131
		) AS q2 ON q2.qry_id > q1.qry_id
CROSS JOIN	(
			SELECT	DISTINCT
				hic_number
			FROM	dbo.DEV_QRY_QC_HCC_131
		) AS h

qry_id hic_number
1       1234546
1       435676756A
2       764321343
3       794674hkf
4       213126786638712

qry_id hic_number
1       1234546
1       435676756A
3       794674hkf

qry_id_2combo hic_number
qry_1&2 123456789A
qry_1&2 987654321A
qry_1&3 456789123B

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'

SELECT		s.hic,
		s.qry,
		f.qry
FROM		@Sample AS s
CROSS APPLY	(
			SELECT		x.qry
			FROM		@Sample AS x
			WHERE		x.hic = s.hic
					AND x.qry > s.qry
		) AS f