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 |
|
snakoil
Starting Member
24 Posts |
 Posted - 2001-06-29 : 09:49:57
|
| Hi guys, I've just founded something really strange. I have a query that uses a group by and a having. My having clause look like this :having sum(total-paid)<>0In SQL7.0, everything's goodin SQL2000, The query doesn't care about the having clause!!!Do you know if there has been some changes in the interpretation of the having in sql2000? Any tips about this is welcome.Mathieu DuhamelSQLServer DBA |
|
|
|
|
|
Changes in "Having"