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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-10-27 : 09:01:21
|
Hi.GROUP BY C.Cinema_strCode, C.Cinema_strName, CASE S.CinOperator_strCode WHEN 'CS' THEN 1 WHEN 'RN' THEN 1 ELSE 0 END, Does that mean that if 1 then S.CinOperator_strCode is taken into account and if 0 the column is ignored?thanks. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-27 : 09:04:28
|
| No, it means:if s.CinOperator_strCode = 'CS' OR s.CinOperator_strCode = 'RN' then put them in the same group, otherwise not. |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-10-27 : 09:22:40
|
| Hm kinda of fuzzy here. There is an inner group on the S.CinOperator_strCode group?Probably need to study group by again. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-27 : 10:38:50
|
| yes, there is an inner group on that column |
|
|
|
|
|
|
what does this case mean?