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 |
|
AlexCold
Starting Member
39 Posts |
 Posted - 2001-03-22 : 06:31:09
|
| [Microsoft][ODBC SQL Server Driver][SQL Server]The sum or average aggregate operation cannot take a bit data type as an argument.SQL = "SELECT f.id, f.foldername, f.sort_order, count(m.id) as count_of_messages, sum(isread) as unread FROM folder f left join message m on f.id = m.folder_id where f.user_id='2974' group by f.id, f.foldername, f.sort_order order by f.sort_order"If I run this query in the Access database all is OK! In the SQL Server all is screw up... Any ideas how to rewrite this query?FAQTeam memberhttp://www.faqteam.org/ |
|
|
|
|
|
Any help is Highly appreciate