Using Cursors Update

Question

0.00/5 (No votes)

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

Please Help :)
Thanks and Regards
Harsha

Posted 15-Nov-12 0:55am

Harsha Dev

Add a Solution

Comments

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 :)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Om Prakash Pant · Answer 1 · 2012-11-15T01:14:00

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:

SQL

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
        -- add the logic you want to add..example
        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