Need help writing code

Question

1.00/5 (2 votes)

See more:

If any can help. I need code that check every time a company has being chosen for something the Referral column to add 1

so if company abc inc is chosen for labor insert the number 1
if company abc inc is chosen for electrical if referral is < 1 add 1 = 2 and so on.

Database Table Company
Columns:
coID
CompanyName nvarchar
Address nvarchar
City nvarchar
State nvarchar
Zip numeric
Services nvarchar
Referral numeric

Posted 23-Jan-11 16:32pm

postonoh

Add a Solution

Comments

shakil0304003 23-Jan-11 22:47pm

Not clear!!!

postonoh 23-Jan-11 22:51pm

Ok.. I have the code that when user check the box for referral it puts a number 1 in the database column referral. so when a user go to save it has to first check to see if check box is check then check the sql server database column referral if not empty add 1 to the existing number.

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)

Mycroft Holmes · Accepted Answer · 2011-01-23T16:50:00

Solution 1

There are a number of things that are wrong with this.

Your company table has event information in it, this should be removed to another table with a FK to the Company table.

ServicesTable
ServiceID
CompanyID
Service
Date Etc...

If you cannot change your data structure then look into row_number, running totals and partition, this assumes sql 2005 or greater

Posted 23-Jan-11 16:50pm

Mycroft Holmes

Comments

postonoh 23-Jan-11 23:05pm

I can change the data structure. no problem. I just need an idea on the best way to do this. with sample code.