13,089,536 members (70,862 online)
Rate this:
See more:
hello guys, i need help Smile | :)

i have a table like this

itemcode itemiicode itemordercode serialnum cpserialnum
4 2 4 21 21
5 2 5 -1 -1
6 3 6 14 14
7 4 7 15 15
8 5 8 41 41
9 6 9 72 72
10 6 10 -1 -1
11 6 11 -1 -1

i want result like below table using Cursors

itemcode itemiicode itemordercode serialnum cpserialnum
4 2 4 21 21
5 2 5 -1 21
6 3 6 14 14
7 4 7 15 15
8 5 8 41 41
9 6 9 72 72
10 6 10 -1 72
11 6 11 -1 72

itemcode is the primary key
Using Cursors we have to update the table

Thanks and Regards
Harsha
Posted 15-Nov-12 0:55am
n.podbielski 15-Nov-12 7:07am

Don't use cursors. And don't expect people in CP to do work for you.
Harsha Dev 15-Nov-12 7:22am

hmm ok podbielski but i have to complete this task in company so oly asking help and i am new to cursors :)

Rate this:

## Solution 1

I am not sure what logic you have put for calculating the last column, but here is an example of using the cursor and updating the table:
DECLARE @field1 int;
DECLARE @field3 int;
DECLARE c1 CURSOR FOR field1, field3 from table1 for update of field3;
open c1;
FETCH NEXT FROM c1 into @field1, @field3
WHILE @@FETCH_STATUS = 0
BEGIN
SET @field3 = @field3 + 20
UPDATE table1 set field3  = @field3 where current of c1
FETCH NEXT FROM c1 into @field1, @field3

END
CLOSE c1;
DEALLOCATE c1;

try doing this without cursors if you can
Harsha Dev 15-Nov-12 7:20am

Thanks Om Prakash :) Here i have not used logic but i need to update the last column with same seraialnum i need to use cursors for swapping or holding variables and get the result

Top Experts
Last 24hrsThis month
 ProgramFOX 270 Richard Deeming 245 Graeme_Grant 220 Jochen Arndt 160 OriginalGriff 149
 OriginalGriff 3,392 Graeme_Grant 1,784 ProgramFOX 1,697 Jochen Arndt 1,645 ppolymorphe 1,457