13,253,863 members (64,351 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 1: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
 Richard Deeming 160 OriginalGriff 150 ppolymorphe 140 GobblesGobbles 129 Karthik Bangalore 120
 OriginalGriff 3,934 Karthik Bangalore 2,231 ppolymorphe 1,589 Dave Kreskowiak 1,301 CPallini 1,240