asked on select (count(job) + job) from AceData group by job ??
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
using ms sql server
the above not working
want to show,
25 myJob
30 otherjob
01 badjob
SQL
Last Comment
goodk
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I tried this, should this be ok? The results looks fine
Select (type +' ('+ ltrim(str(count(type))) +')' ) as xtest from AceData group by type
Select (type +' ('+ ltrim(str(count(type))) +')' ) as xtest from AceData group by type
ASKER
thanks
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
In programming trick is to make things simple not complicated
Select (type +' ('+ convert(varchar,count(type)) +')' )
ASKER
thanks
resolved used str() to convert