ADD thousands separators to an Aggregate Sum SQL

Asked Nov 01 '21 at 17:05

Active Nov 01 '21 at 17:11

Viewed 50 times

I am trying to add thousands seperators in an SQL request. I want to add it on a SUM function, so that the resulting column shows the dati with the thousands separator from 400000.00 to 400,000.00

That is the line I am trying to fix. ROUND(SUM(soh.SubTotal),2) as 'Ventes en 2013' --> this means "Sales in 2013"

Thank you !

edited Nov 01 '21 at 17:11

squillman

13,363
3
41
60

asked Nov 01 '21 at 17:05

LostITStudent

1

Which database platform are you using? Also, if you have a ui / reporting / presentation layer you should consider doing this type of formatting work there instead of in the database. – squillman Nov 01 '21 at 17:06
Hey ! I am using the database AdventureWorks2019 if this is what you're asking. Also, I don't think I have the ui/reporting presentation layer you're mentionning. – LostITStudent Nov 01 '21 at 17:09
Ok, if you're using AdventureWorks2019 then you're most likely using SQL Server 2019. Is that correct? – squillman Nov 01 '21 at 17:10
Yes that's the one – LostITStudent Nov 01 '21 at 17:10
@squillman Yes it worked ! Thank you so much ! – LostITStudent Nov 01 '21 at 17:19

ADD thousands separators to an Aggregate Sum SQL

0 Answers0