How to display the % sign with the returned results
Posted on 2012-04-12
I'd like to have the % sign displayed when the query below returns the percentage results. How can that be accomplished? Thanks for your help.
declare @total decimal
select @total = COUNT(*)
Select COUNT(*) as [Count], cast(COUNT(*)/@total*100 as numeric(10,0)) as [Percentage], Letter
group by Letter