13 May 2015 by Maciej Los
Check this:DECLARE @tmp TABLE (Username VARCHAR(250), WorkArea VARCHAR(50), Scope VARCHAR(50), Quality INT)INSERT INTO @tmp (Username, WorkArea, Scope, Quality)VALUES('aa,bb,cc,ee,ff,gg,hh,ii', 'xyz', 'zyx', '100'),('aa,bb,dd,ii,kk', 'xyz', 'zyx', '99'),('cc,gg,ee,hh,kk', 'xyz',...