IF OBJECT_ID('dbo.TAB1') IS NOT NULL
	DROP TABLE dbo.TAB1

CREATE TABLE TAB1 (
	COLUMN11 NVARCHAR(10) NOT NULL,
	COLUMN12 NVARCHAR(10) NOT NULL,
	COLUMN21 NVARCHAR(10) NOT NULL,
	COLUMN22 NVARCHAR(10) NOT NULL,
    id int identity unique,
	PRIMARY KEY CLUSTERED (COLUMN11, COLUMN12, COLUMN21, COLUMN22)
)

INSERT INTO TAB1
VALUES 
('111', '01', '111', '02'),
('111', '02', '111', '03'),
('111', '03', '222', '01'),
('222', '01', '222', '02'),
('222', '02', '111', '02'),
('333', '01', '333', '02'),
('333', '02', '333', '03'),
('333', '03', '333', '01')

go

;WITH c AS ( SELECT id, 0 AS cnt, Cycle = cast(0 as bit), COLUMN11 AS beg1, COLUMN12 AS beg2 FROM TAB1
             UNION ALL
            SELECT c.id, c.cnt + 1 as cnt, Cycle = cast(iif(c.id = n.id, 1, 0) as bit), n.COLUMN11 AS beg1, n.COLUMN12 AS beg2
                FROM c 
                JOIN TAB1 AS n on c.beg1 = n.COLUMN21 AND c.beg2 = n.COLUMN22
                WHERE c.Cycle = 0
    )
    , ac as ( SELECT * FROM c where exists( select * from c as x where x.id = c.id and x.Cycle = 1 ) )
  select * from ac
    where not exists( select * from ac as x where x.id < ac.id 
                                    and not exists(select beg1, beg2 from ac as y where id = x.id except select beg1, beg2 from ac as y where id = ac.id) 
                                    and not exists(select beg1, beg2 from ac as y where id = ac.id except select beg1, beg2 from ac as y where id = x.id)
                      )
    ORDER BY id, cnt