Hi Dwain ,

Thanks for the Reply . I am Looking a Generic Solution for issue (not upto combinations up to 3).

If you Look the Attachments in my...

My Initial Data Sample Still valid ...but I mentioned the all possible Combinations in my latest post

DECLARE @ClassID TABLE (Class INT, Product INT)

DECLARE @ProductClass TABLE(Product INT, Class INT)

---@ProductClass table Product...

In Table A , Any number of Classes can be Grouped to a Group

In Table A , Same set of Classes Cannot be Grouped

In Table B I...

Thanks very much. Its impressive work..