cursors in sqlserver

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi,
i required some help from you....

i have 2 tables,

1.usertable with columns (userid,username,usertype)

here we can give usertype=employee or customer,if it is employee in uerdetails table i need to update emp count = 1,
include with this i need to update this records to all previous registered user records...like a chain system

2.userdetails table with columns(userid,userscount,emp.count,cust.count)

here,main thing is if iam a new registered user,then all particular counts should be updated to previous registered users.

Posted 21-Dec-11 18:35pm

Member 7968468

Updated 21-Dec-11 18:43pm

v2

Add a Solution

2 solutions

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)

Wendelius · Answer 1 · 2011-12-21T19:05:00

Solution 1

If I understood correctly, you would like to update calculated information in some table based on other tables. If that's the case I suggest you don't do that. Storing calculation (such as count, multiplications etc) results in the the database will typically lead to problems.

Instead do the calculations when you fetch the data. This way you always get the right results and you have less SQL statements to execute in insert/update phase.

Posted 21-Dec-11 19:05pm

Wendelius

Comments

thatraja 22-Dec-11 14:54pm

Storing calculation (such as count, multiplications etc) results in the the database will typically lead to problems
Ofcourse I agree. Nice suggestion, 5!

Wendelius 22-Dec-11 15:00pm

Thanks, actually I wasn't unconditional since there are cases when this makes sense, especially reporting environments. After all, thats one reason for ELT process :)

Monjurul Habib · Answer 2 · 2011-12-21T20:15:00

Solution 2

Following are simple examples:
Simple cursor Example in Microsoft SQL Server
SQL SERVER Simple Example of Cursor
DECLARE CURSOR
Cursors: An Overview
Built-in Functions - Cursor Functions

Posted 21-Dec-11 20:15pm

Monjurul Habib

Updated 21-Dec-11 20:16pm

v2

Comments

thatraja 22-Dec-11 14:56pm

Yep, He need row by row operation so he must go with cursor or while loop or any other alternatives, 5!

Monjurul Habib 22-Dec-11 14:59pm

thank you