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