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 |
|
Dan27
Starting Member
3 Posts |
 Posted - 2009-06-18 : 04:10:44
|
| HelloHoping someone can help. I have a really limited knowledge of SQL but wish to convert the following excel formula into an SQL statement.=A1*(1/B1)Where A1 is my field value and B1 is a percentage of A1,A2,A3. For exampleSales North 3 16.6%East 6 33.3%West 9 50.0%Sorry to demonstrate this as excel but was unsure how else to express.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-18 : 04:16:41
|
= 1.0E * A1 / B1
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
A formula in SQL