SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 problem regarding UPDATE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lamiajoyee
Starting Member

15 Posts

Posted - 01/17/2012 :  05:39:56  Show Profile  Reply with Quote
i want to increment the current salary of employees by adding some overtime fees. im trying to accomplish this by the following statement

UPDATE overtime	SET osalary=osalary+total where   overtime.eid=something

here 'total' is the amount to be incremented.but this statement is not working.please help

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 01/17/2012 :  06:01:29  Show Profile  Visit webfred's Homepage  Reply with Quote
'total' is coming from where?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

lamiajoyee
Starting Member

15 Posts

Posted - 01/17/2012 :  06:47:44  Show Profile  Reply with Quote
'total' is an integer.it is coming from c#
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 01/17/2012 :  07:04:57  Show Profile  Visit webfred's Homepage  Reply with Quote
Maybe you can show us a bit more on what you are really doing/coding because the shown example above should work.
And maybe you can make more clear the meaning of "is not working" - any errors or what?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000