[T-SQL] How to put $ symbol in the query or result set |
| How to put $ symbol in the query or result set Posted: 24 Aug 2013 01:38 AM PDT i have this querySELECT ContactID,AVG(TotalDue) AS [Avergare Total Due] FROM Sales.SalesOrderHeader GROUP BY ContactID ORDER BY 1 ASCwhat i want to i want prefix dollar symbol in the [Avergare Total Due]ContactId [Avergare Total Due]1 $25109.71742 $38125.4613 $57475.58774 $51255 $75337.5394 |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment