<div>
Don't think the problem really is the nvarchar. You're definitely on the right track, but simply may need to sum what you just queried.<br />
<br />
Try this:<br />
<br />

<pre><code id="code-20-39217199-1">Select  ci,
        SUM(cnt) AS cntSum
From  ( Select  Company_Id AS ci,
                count (distinct Order_Number) AS cnt
        From    TableA
        Having  Count(Order_Number) &gt;1 ) t1
Group By ci</code></pre>
I added the &quot;AS&quot; simply for readability.
</div>


Don't think the problem really is the nvarchar. You're definitely on the right track, but simply may need to sum what you just queried.

Try this:



Select  ci,
        SUM(cnt) AS cntSum
From  ( Select  Company_Id AS ci,
                count (distinct Order_Number) AS cnt
        From    TableA
        Having  Count(Order_Number) >1 ) t1
Group By ci

I added the "AS" simply for readability.

<div>
Hey dsacker thanks for the help.<br />
<br />
After implementing your solution I still get <br />
<br />
Ci &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cnt<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15<br />
<br />
I need just one row sum result on cnt:<br />
<br />
cnt<br />
33
</div>


Hey dsacker thanks for the help.

After implementing your solution I still get

Ci            cnt
1               10
2                 2
3                 6
4               15

I need just one row sum result on cnt:

cnt
33

<div>
<div class="content wysiwyg-content">
Current:<br />
Select &nbsp;Company_Id ci, count (distinct Order_Number) cnt<br />
From TableA<br />
Having &nbsp;Count(Order_Number) &gt;1<br />
<br />
Order Number is a alpha numeric, example PQR0725102115, and is nvarchar.<br />
<br />
Yields:<br />
<br />
Ci &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cnt<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15<br />
<br />
Desired result:<br />
<br />
I need the sum of the cnt column:<br />
<br />
cnt <br />
33<br />
<br />
The problem is in the nvarchar.
</div>
</div>


Current:
Select  Company_Id ci, count (distinct Order_Number) cnt
From TableA
Having  Count(Order_Number) >1

Order Number is a alpha numeric, example PQR0725102115, and is nvarchar.

Yields:

Ci            cnt
1               10
2                 2
3                 6
4               15

Desired result:

I need the sum of the cnt column:

cnt 
33

The problem is in the nvarchar.

How do I sum a count on nvarchar.

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.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.