Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asstman37
Starting Member
1 Post |
 Posted - 2012-03-24 : 18:23:11
|
| I am trying to increase all employee salaries by 10% using these columns from my Employee table.EmployeeID Lastname Firstname [Address] City [State] Telephoneareacode Telephonenumber EEO1Classification HireDate Salary Gender Age JobIDlou vega |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-24 : 19:30:37
|
yes. What have you tried ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-24 : 20:28:10
|
| hint: use an UPDATE------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-03-25 : 02:35:01
|
| Adapt for the UPDATE statement declare @salary decimal(10,2)set @salary = 500.00PRINT @salarySET @salary = @salary + ((@salary / 100)*10)--increase by 10%PRINT @salaryJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2012-03-26 : 01:45:41
|
now that's a problem you will never encounter in any real business...
elsasoft.org |
|
|
|
|
|
|
Salery Increase