Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • Reply To: Record counts from the table

    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...

  • Reply To: Help Edit Query

    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 9 months, 3 weeks ago by  Med Anwar.
  • Reply To: Record counts from the table

    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 9 months, 3 weeks ago by  Med Anwar.
  • RE: Remove successive rows with same column value

    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...

Viewing 4 posts - 1 through 4 (of 4 total)