I have a query that does the following:
Select acct_tran, count(acct_nbr) From transactiontbl Group By acct_tran Order By count(acct_nbr) desc
Result shows Tran HowMany
How can I get it to display as
Thanks in advance.
SELECT CONVERT(varchar, CAST(2490287 AS money), 1)
Select acct_tran, CONVERT(varchar, CAST(count(acct_nbr) AS money), 1) From transactiontbl Group By acct_tran Order By count(acct_nbr) desc
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?