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.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 what does this case mean?

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.
Go to Top of Page

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.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-27 : 10:38:50
yes, there is an inner group on that column
Go to Top of Page
   

- Advertisement -