Archives of the TeradataForum

Message Posted: Fri, 20 Aug 2010 @ 15:09:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

HI,

Source data:

     RPTID   BM
     121     A
     121     B
     122     C
     122     D
     123     B
     123     D
     124     A
     124     B
     125     C
     126     A
     126     C
     126     D

2. Result

     B
     C

3. Def: What are the minimum BM's to have to return all the RPT_ID's?

In the above source data B is in 121,123,124 and C is in 122,125,126 which cover all the RPT_ID's hence our results are B and C. There may be another set of such BM which covers all the RPT_ID. I need a minimum BM to cover all the RPT_ID's

Regards,

Hanumath

	<Prev	Next>		<<First	<Prev	Next>	Last>>