Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-01-10 : 11:21:32
|
| I can concatenate the dataprocessed and checkamount,but I can't concatenate the count(Id) part... Can you take a look at the below query and let me know what I am doing wrong?SELECT distinct(dateprocessed), convert(varchar(10), [DateProcessed],121 )+ ' $' + convert(varchar(10), convert(Decimal(10,2), sum(CheckAmount)))+ convert(varchar(4), count(convert(varchar(4), ID )) ) as Listfrom IDXCDdata b WHERE Appliedcash = 0 and DocumentType = 'Check' group by DateProcessed |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-01-10 : 11:28:22
|
| Nervermind.. I fixed the problem.Thanks! |
 |
|
|
|
|
|
concatenation problem