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 |
|
vinurvk
Starting Member
8 Posts |
 Posted - 2010-12-22 : 06:10:48
|
| Table1 contains column a, b, c & dcolumn a contains the namecolumn b & c contains numbers.i want to update column d with values based on column b & cEg = Column D = (Column C / column B)for every row of a.. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-12-22 : 06:20:43
|
| select a,b,c,1.0*c/b as d from your_tableMadhivananFailing to plan is Planning to fail |
 |
|
|
vinurvk
Starting Member
8 Posts |
Posted - 2011-02-26 : 14:19:13
|
| thats perfect... it works.. |
|
|
|
|
|
|
Help me with Update Statement