Hi Experts, I need to do is remove all the words that are not contained in every record of the each groupingid group .That is I need is a way to strip out any text from a group that is not contained in all rows of the group with a space as deliminatorCREATE TABLE #TEMP (GROUPINGID INT ,DESCRIPTION VARCHAR(MAX))INSERT INTO #TEMPSELECT 2,'Hat red' UNION ALLSELECT 2,'Hat green' UNION ALLSELECT 2,'Hat yellow' UNION ALLSELECT 3,'Yellow Mens Sweater' UNION ALLSELECT 3,'Green Mens Sweater' UNION ALLSELECT 4,'ENDURO STYLE GRIPS BLUE' UNION ALLSELECT 4,'ENDURO STYLE GRIPS RED' UNION ALLSELECT 4,'OURY STD GRIP/BLACK/LOW FLANGE' UNION ALLSELECT 5,'PLEXUS 1/2 OUNCE' UNION ALLSELECT 5,'PLEXUS 7 OUNCE' UNION ALLSELECT 5,'PLEXUS 13 OUNCE'GROUPINGID DESCRIPTION2 Hat red2 Hat green2 Hat yellow3 Yellow Mens Sweater3 Green Mens Sweater4 ENDURO STYLE GRIPS BLUE4 ENDURO STYLE GRIPS RED4 OURY STD GRIP/BLACK/LOW FLANGE5 PLEXUS 1/2 OUNCE5 PLEXUS 7 OUNCE5 PLEXUS 13 OUNCEExpected output:groupid description2 Hat3 Mens Sweater4 NULL (this is null because the same word is not repeated in all rows)5 PLEXUS OUNCE
Please help me.Thanks!