Re: [SQL] Help me do a LOOP

Calin Meze wrote: I need to test each record of a cursor for some requirements, something like this [snip] -- the problem is that I do not know how to make the while loop execute until the last record "WHILE (still in the cursor)"... So I need something like Can anyone help me with this? It

[SQL] Help me do a LOOP

 I need to test each record of a cursor for some requirements, something like thisDECLARE xpvnr varchar(50);  xdata date;  xcod int;  xagentd varchar(3);  xid bigint;  xserie varchar(4);  xnr varchar(7);  xsocasig varchar(3); DECLARE myCursor CURSOR FOR