<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Ask Ben: Querying Groups With Conditional Elements Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1121.view Date Posted: Jan 14, 2008 at 7:00 AM ---- --------------------------------------------------------------------------------------- ---> DECLARE @data TABLE ( trans_id INT, tag_id INT ); INSERT INTO @data ( trans_id, tag_id )( SELECT 1, 1 UNION ALL SELECT 1, 2 UNION ALL SELECT 2, 1 UNION ALL SELECT 2, 2 UNION ALL SELECT 2, 3 UNION ALL SELECT 3, 3 UNION ALL SELECT 3, 4 );