Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency format from a sum in a query
Message
From
26/11/2008 22:26:41
Edgar Salcedo
Bogotá, Colombia
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Currency format from a sum in a query
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01364335
Message ID:
01364335
Views:
59
I have this query:

SELECT Prospecto.Nombre, SUM(Propuesta.PresupuestoCOP) AS TotalCOP, SUM(Propuesta.PresupuestoUSD) AS TotalUSD, COUNT(Prospecto.Nombre)
AS TotalProspectos
FROM Propuesta INNER JOIN
Prospecto ON Propuesta.IdProspecto = Prospecto.IdProspecto
GROUP BY Prospecto.Nombre
ORDER BY Prospecto.Nombre

And I need to express the SUM in currency format, how can I achive this?
Next
Reply
Map
View

Click here to load this message in the networking platform