You are welcome, the first code will not work if you have too much level hierarchie .

For your structure you can try the following code, let me know if it...

It's bad idea but you can do "edit top 200 rows" to display your grid then switch to sql script (shortcut by default Ctrl+3) remove TOP (200) and execure your...

• This reply was modified 5 years, 1 month ago by  Med Anwar.

Hello, if I understand you need somethink like this :

DECLARE @MyCatalog TABLE(
[idtable] int NOT NULL,
[idparent] int,
[nameCatalog] varchar(50)
);

INSERT INTO @MyCatalog VALUES(1,NULL,'CORP');
INSERT INTO @MyCatalog VALUES(2,1,'IT');
INSERT INTO @MyCatalog VALUES(3,1,'HR');
INSERT INTO...

• This reply was modified 5 years, 1 month ago by  Med Anwar.

Hello everyone. I'm sorry if I took time to answer you I was not home this weekend.

Thank you for your response ! your proposals are very interesting especially the solution...