<div>
I've requested that this question be deleted for the following reason:<br />
<br />
resolved used str() to convert
</div>


I've requested that this question be deleted for the following reason:

resolved used str() to convert

<div>
I tried this, should this be ok? &nbsp;The results looks fine<br />
Select (type +' ('+ ltrim(str(count(type))) +')' ) as xtest from AceData group by type
</div>


I tried this, should this be ok?  The results looks fine
Select (type +' ('+ ltrim(str(count(type))) +')' ) as xtest from AceData group by type

<div>
Yes that will work but why use to functions when you can get away with one<br />
<br />
In programming trick is to make things simple not complicated<br />
<br />

<pre><code id="code-20-38731727-1">Select (type +' ('+ convert(varchar,count(type)) +')' )</code></pre>
</div>


Yes that will work but why use to functions when you can get away with one

In programming trick is to make things simple not complicated



Select (type +' ('+ convert(varchar,count(type)) +')' )

<div>
<div class="content wysiwyg-content">
select (count(job) + job) &nbsp;from AceData &nbsp;group by job <br />
<br />
using ms sql server<br />
<br />
the above not working<br />
<br />
want to show,<br />
<br />
25 myJob<br />
30 otherjob<br />
01 badjob
</div>
</div>


select (count(job) + job)  from AceData  group by job 

using ms sql server

the above not working

want to show,

25 myJob
30 otherjob
01 badjob

select (count(job) + job)  from AceData  group by job ??

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.