How do I select records that meet this criteria:
The selection must include all the unique values from Columns B & C and min. 10% of the unique values from Col D. Ideally select the smallest set of data that meets the 3 criteria.
Is this type of Query possible in T-SQL (SQL 2005) ?
Is it possible in any related Microsoft BI tool, SQL 2005 or SQL 2012 ?