• Why it is my query designer keeps hanging (not responding)

    compiling this query. any idea guys. thanks.

    While (1=1)

    BEGIN

    INSERT inTO ...

    SELECT * FROM WHERE

    IF @@ROWCOUNT = 0

    BEGIN

    SET @PFromDateInside=@PFromDateInside -1

    SET @PToDateInside=@PToDateInside-1

    ENDIF

    ELSE

    BREAK

    END

    OR

    While (1=1)

    BEGIN

    INSERT inTO ...

    SELECT * FROM WHERE

    IF @@ROWCOUNT >=0

    BREAK

    ELSE

    BEGIN

    SET @PFromDateInside=@PFromDateInside -1

    SET @PToDateInside=@PToDateInside-1

    END

    END