<div>
sorry miss the @ before sumTotal<br />

<pre><code id="code-8139630">Declare @sumTotal float
select @sumTotal = sum(TOTAL) from SELL

SELECT CLIENT, TOTAL, (TOTAL / @sumTotal) as [Percentage] FROM SELL</code></pre>
</div>


sorry miss the @ before sumTotal


Declare @sumTotal float
select @sumTotal = sum(TOTAL) from SELL

SELECT CLIENT, TOTAL, (TOTAL / @sumTotal) as [Percentage] FROM SELL

<div>
you must select the sum of Total in a variable separately in-order to enhance performance
</div>


you must select the sum of Total in a variable separately in-order to enhance performance

<div>
<div class="content wysiwyg-content">
Hello guys<br />
<br />
I have this query:<br />
<br />
SELECT CLIENT, TOTAL FROM SELL<br />
<br />
Unless I have the Total, I want the percentual<br />
<br />
is it possible? thanks
</div>
</div>


Hello guys

I have this query:

SELECT CLIENT, TOTAL FROM SELL

Unless I have the Total, I want the percentual

is it possible? thanks

how can I get a percentual in my query from a total field?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.