All I want are records that have all the matching grouporitem belongs to code 'ABC' in other profiles should be an exact match of grouporitems in each profile.

Here is the complete script and output

DECLARE @Sample TABLE

(

Code CHAR(4) ,

IGP VARCHAR(255) ,

[Description] VARCHAR(255) ,

GroupOrItem CHAR(4)

) ;

INSERT INTO @Sample

VALUES (...