<div>
select id, period, data1*data2 as data4, (data1*data2) / data3 as data5<br />
from yourtable<br />

</div>


select id, period, data1*data2 as data4, (data1*data2) / data3 as data5
from yourtable


<div>
is it possible to amend similar to the following:<br />
select id, period, data1*data2 as data4, data4/data3 as data5<br />
from yourtable
</div>


is it possible to amend similar to the following:
select id, period, data1*data2 as data4, data4/data3 as data5
from yourtable

<div>
<div class="content wysiwyg-content">
Given the following Table<br />
ID &nbsp;PERIOD &nbsp; &nbsp; DATA1 &nbsp;DATA2 &nbsp; DATA3<br />
A &nbsp;20071001 &nbsp; &nbsp;32 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23<br />
B &nbsp;20071001 &nbsp; &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<br />
C &nbsp;20071001 &nbsp; &nbsp;46 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15<br />
<br />
How can I run a select statement that would<br />
DATA1*DATA2 = DATA4<br />
DATA4/DATA3 = DATA5<br />
All in the same select statement<br />
<br />
Desired results would be:<br />
ID &nbsp;PERIOD &nbsp; &nbsp; &nbsp;DATA4 &nbsp; &nbsp;DATA5<br />
A &nbsp;20071001 &nbsp; &nbsp; 128 &nbsp; &nbsp; &nbsp; &nbsp;5.57<br />
B &nbsp;20071001 &nbsp; &nbsp; &nbsp;220 &nbsp; &nbsp; &nbsp;44.00<br />
C &nbsp;20071001 &nbsp; &nbsp; &nbsp;552 &nbsp; &nbsp; &nbsp;36.80<br />
<br />
Also, I would need the statement to account for divide by zero issues.<br />

</div>
</div>


Given the following Table
ID  PERIOD     DATA1  DATA2   DATA3
A  20071001    32           4             23
B  20071001    22          10            5
C  20071001    46          12            15

How can I run a select statement that would
DATA1*DATA2 = DATA4
DATA4/DATA3 = DATA5
All in the same select statement

Desired results would be:
ID  PERIOD      DATA4    DATA5
A  20071001     128        5.57
B  20071001      220      44.00
C  20071001      552      36.80

Also, I would need the statement to account for divide by zero issues.


Multiply two variables then divide by third variable in same table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.